SQL alternative to requery command

[mrliam69]

I have a problem with a continuous form that uses the form.requry command on a 2 minute interval to refresh the information. The form is about 2 screen sizes long and when the requery command is run the screen jumps and if the user was scrolled down near the bottom it would suddenly shoot up to the top. Is there an alternative SQL statement that can refresh the data without jumping the screen around ?

Liam

 

[pweegar]

How are you openning your recordset? Try openning it using ADO and open the recordset with adOpenDynamic. Adds, deletes, deletions should be made by other users should be seen by the recordset. This may eliminate the need for a requery.

What fires tyour requery? You could set a "book mark" (use a variable to hold where the user was working prior to the requery) and set the focus back to where the user was.

 

[mrliam69]

The continuous form gets its info via FORM -> DATA -> RECORD SOURCE ... and looks at a custom VIEW (VIEWProductionOrders2) I wouldn't know how to do it via ADO but maybe I should.
What would be a good starting point ?

Liam