Access 2007 listbox won't refresh
| Author |
Message |
iker
|
 Posted: 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! |
|
|
|
|
 |
Sponsor
Sponsor
|
|
|
iker
|
| Posted: 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 |
|
|
|
|
|
|
|
Register
Wiki
Blog
Search
Turing
Chat Room
Members
