List Box - Select All

[Guest]

My query searches my table of employee records based on three possible
selections from a list box - "Active" - "Retired" - "All". When I select
Active or Retired it works ok - how can I get the query to show all records
when "All" is selected in the List Box since none of the records have that
value ?

This is the formula I am using in my query

Like [Forms]![F-Print-By-Flt]![List16]

Thanks

 

[Guest]

Set the criteria to something like:
Like [Forms]![F-Print-By-Flt]![List16] or [Forms]![F-Print-By-Flt]![List16]
= "All"

BTW: you should do yourself a favor and change List16 to something more
descriptive.

 

[Guest]

That works ....

And thanks for the advise...

Set the criteria to something like:
Like [Forms]![F-Print-By-Flt]![List16] or [Forms]![F-Print-By-Flt]![List16]
= "All"

BTW: you should do yourself a favor and change List16 to something more
descriptive.
--
Duane Hookom
Microsoft Access MVP

My query searches my table of employee records based on three possible
selections from a list box - "Active" - "Retired" - "All". When I select
Active or Retired it works ok - how can I get the query to show all records
when "All" is selected in the List Box since none of the records have that
value ?

This is the formula I am using in my query

Like [Forms]![F-Print-By-Flt]![List16]

Thanks