Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms Programming / February 2008

Tip: Looking for answers? Try searching our database.

Refreshing list boxes

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
fiona.innes@metacor.co.uk - 29 Feb 2008 11:42 GMT
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
works a treat ta

F
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.