Requery

[Gary Robinson]

Hi All

I have 3 or 4 people accessing the same DB, when one person adds a new
record, the other can't see that record until they have come out of the
form, and loaded back in.

I have tried to use Requery, setting it to run whenever someone moves
records so it will update the new records for everyone else to see. But the
problem is when I run docmd.requery it always takes the user to the first
record. I have tried to make the system return to the current record when
it has run the requery, but this does not 'look good' to the end user.

Is there a better and more efficient way of doing this??

Thanks in advance


Gary

 

[Wayne Morgan]

You might try the DoCmd.Echo command. Turn echo off before you requery and
on again after you've repositioned to the previous record. Don't forget to
set it to True in your error handler also in case there is an error while it
is set to false.

DoCmd.Echo False
DoCmd.Echo True