Selecting all items in drop-down list

  • Thread starter Thread starter Matt K.
  • Start date Start date
M

Matt K.

I am using a form's drop down list to feed a parameter in
a query. When the user selects an item, the query uses
that item as one of the criteria. I need to modify a
drop-down list so that "All" is one of the selections.
When the user selects "All" I want no criteria so that
the query shows all records in the table.

For instance, a table contains 3 employees (John, Sue,
Bob). When the user selects "Bob" the query shows Bob's
records. If the user were to select "All," John's,
Sue's, and Bob's records will show.

I know that there was an article in the Knowledge Base
about this a few years ago, but I cannot find it any
more. Any thoughts?
 
I am using a form's drop down list to feed a parameter in
a query. When the user selects an item, the query uses
that item as one of the criteria. I need to modify a
drop-down list so that "All" is one of the selections.
When the user selects "All" I want no criteria so that
the query shows all records in the table.

For instance, a table contains 3 employees (John, Sue,
Bob). When the user selects "Bob" the query shows Bob's
records. If the user were to select "All," John's,
Sue's, and Bob's records will show.

I know that there was an article in the Knowledge Base
about this a few years ago, but I cannot find it any
more. Any thoughts?
Click to expand...

Here ya' go.

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

- Jim
 
Back
Top