Computer Science Canada Access 2007 listbox won't refresh |
| Author: | iker [ Fri May 14, 2010 3:14 pm ] |
| Post subject: | Access 2007 listbox won't refresh |
Ok, so I'm working on a little database now using microsoft access 2007(day 2 of learning this stuff). I have a text field that must be filled in before querying the database for a list. Enter a city name and all of the employees in that city SHOULD pop up in the listbox below - well its doesn't refresh untill I press F9. My listbox has rowsource = "query" I've tried using VB to do a me.listbox.requery.. didn't work I've tried using the OnChange event to set listbox.rowsource = "query".. also fail Any suggestions? Help is greatly appreciated! |
|
| Author: | iker [ Mon May 17, 2010 3:28 pm ] |
| Post subject: | Re: Access 2007 listbox won't refresh |
Figured out a nice little fix.. I just added a built in refresh button.. but for whatever reason when I coded refresh in VB, it wouldn't work. Anyways I don't need help anymore |
|