Refreshing list boxes

[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

 

[mscertified]

Lookup REQUERY in Access help
You can add a button to a form with the wizards.

-Dorian

 

[smk23]

Hi Fiona:
Make a command button with label "refresh" or whatever you like. In the code
behind the command button, just requery your list box:

Me.NameOfYourListBox.Requery

 

[fiona.innes]

works a treat ta

F