If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Listboxes
I have a form that has drop down lists that allow the users to choose
specific criteria. The associated query, behind the form, uses that criteria filter records. The listbox gets is list from a seperate query that groups the contents of the list, in that given field. My problem is that I don't know how to make a listbox provide an option that tells to query to give everything. Right now the listbox works great in letting users choose something to filter by, but what's the best way to have a list to choose from, that either 1) when you choose nothing, the query gives everything 2) have an option in the list that makes the query give everything Thanks beforehand |
#2
|
|||
|
|||
Listboxes
http://www.mvps.org/access/forms/frm0043.htm
Then you have to code for it... (add NO filter to whatever records you are returning). -- Message posted via http://www.accessmonster.com |
Thread Tools | |
Display Modes | |
|
|