List Box - Select All

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
 
That works ....

And thanks for the advise...



Duane Hookom said:
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


George said:
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
Click to expand...
Click to expand...
 
Back
Top