I haven't looked at this form in ages (done in original 7.0, before we even had
properties), but this merits a re-check! I'm going to try your solution!
Karen
For shortcut in navigating through a thousand records with having the form based on a view (tvTest)
Place a variable on the form called vWhere and then have a button with this eep
DROP VIEW tvTest
CREATE TEMP VIEW tvTest AS SELECT column from table WHERE &vWhere
PROPERTY TABLE tvTest 'REFRESH'
It allows for changing the where clause without closing the form.
