HELP-Database Requery

[PK]

How do I allow Access to requery all of the data without pushing shift+F9 all
the time? I am taking orders on one computer on the network and processing
them on another computer, all through Access. If I push the shift+F9 it
brings me back to the newest order entry. I just want it to gather all new
data for the database but keep me working on the same page as normal. The
entire page must be requeryed also, and contains a main form and two
subforms. HELP!!

 

[Sylvain Lafontaine]

Instead of pressing Shift+F9, you should add a button that will store the
current ID (or bookmark), then execute the requery and after go back to the
desired ID. You will find many examples of this on the web.

You can also try the Resync command instead of the Requery but I don't know
if it will gather all the data that you need.

Finally, you can add a field somewhere to tell when the form on one location
need to be refreshed and check it periodically with a timer command.

S. L.

You don't tell us if you have access to the VBA code of your application