refreshing a list box

[fiona.innes]

Hi,

I have created a database so that mulpile users can add detailss to
the table - tblDetails from the form frmDetails or amend details in
form frmAmend. I have a list box on the main page frmMain which has a
list box lstSearch which shows all the records in the database. When
users add new record to the database other users cannot see the added
records unless the move to another section in the datbase and the
return to the main page thus refreshing the list box. Can anyone tell
me if there is a way I can put a "Refresh" button on the main page
that updated the list box if the user clicks on it? If so how is this
done.

Thanks Fiona

 

[Klatuu]

Is sounds like you have multiple people sharing the same copy of your mdb.
You should not do that. Your database should be split and the _be version
should be in a shared folder to which all users have access and each user
should have their own copy of the front end on their computers.

Even sharing one copy as you are, you wont be able to have every user's form
see the newly added record. Even when they are sharing a copy, each user
computer is running their own instance of the app on their own computer.

But, in any case, the only way to cause the other users to see newly added
records is to use the form Timer event to periodically requery the list box.