I have five users using the same forms to enter and retrieve data from
an Access database held on a server but the only way each user can see
any changes to records is by closing and reopening the database

Ive created a refresh button on each form to refresh the data but
still no luck, I think it failed because it's over a network but not
sure - can somebody provide me with the code that I add to the refresh
button.

Thanks, Bill

"Bill" <bmcconnell21 (AT) hotmail (DOT) com> wrote

Refresh show changes to records already loaded. To see new records you need
Requery. This will take the user back to the first record in the RecordSet so
it's not something you would want to do automatically because it would interfere
with data entry.

You could have a button though that would store the Primary Key of the current
record, Requery the form, and then take the user back to the record they were
on. Not a very good use of network bandwidth though.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com