Share Data update

[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

 

[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."

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com

 

[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.