Listboxes

[Jacques Latoison]

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

 

[PieterLinden via AccessMonster.com]

http://www.mvps.org/access/forms/frm0043.htm

Then you have to code for it... (add NO filter to whatever records you are
returning).