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 - 29 Feb 2008 14:46 GMT
Lookup REQUERY in Access help
You can add a button to a form with the wizards.
-Dorian
> Hi,
>
[quoted text clipped - 10 lines]
>
> Thanks Fiona
smk23 - 29 Feb 2008 14:50 GMT
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
> Hi,
>
[quoted text clipped - 10 lines]
>
> Thanks Fiona
fiona.innes@metacor.co.uk - 29 Feb 2008 15:43 GMT