Share Data update

T

Tony WONG

The front side is Access 2007
The back end is SQL2000

Sometimes, User A cannot view/search the User B's input, event half hour.

But they can do after logout and login the database again.

is there anything i can fine tune for it? Thanks.

Tony
 
L

Linq Adams via AccessMonster.com

From inside the code module for any form in your database, fire up Access
Help and search on the term * Refresh Method * I think this is probably what
you need!

from Help:
"The Refresh method immediately updates the records in the underlying record
source for a specified form or datasheet to reflect changes made to the data
by you and other users in a multiuser environment."
 
T

Tony WONG

Thanks a lot for your advice.

it solved the sub form issue.

however there is a dropdown list (bind to a table)

how can i refresh to dropdown list when it is on Focus? Thanks.
 
Top