 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms Programming / August 2006Refresh
I have a a list box that getting its data from a table. The list box is called LB the Table is called table1 and has only one filed called Field1 What event and what code should be in the event for the list box to be refreshed with the data from table1 Field1 each time I a, pressing a button (let's say Button1) Many thanks Mark Depends on how you populate the Listbox... If You bind it to Table/query & use Rowsource=Table1 then: Sub Command1_click() Me!Lb.Requery End Sub should do it HTH Pieter > I have a a list box that getting its data from a table. > [quoted text clipped - 8 lines] > Many thanks > Mark Thanks, Mark > Depends on how you populate the Listbox... > If You bind it to Table/query & use Rowsource=Table1 [quoted text clipped - 21 lines] > > Many thanks > > Mark Will this blank the list box for the next record? My problem is that when I need to add a new record, the previous entries are still there. > Depends on how you populate the Listbox... > If You bind it to Table/query & use Rowsource=Table1 [quoted text clipped - 21 lines] > > Many thanks > > Mark |
Reply to this Message |
 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.