Creating a filter for a list box

  • Thread starter Thread starter Turner.John.P
  • Start date Start date
T

Turner.John.P

I want to create a filter for a list box that I can turn off and on
using a check box on the same form. Currently, I am using a query to
filter the list box. The query serves as the data source for the box.
Is there a way I can create a filter and then turn it on and off using
a check box? Thank you for your help.

Best,

John
 
Use criteria in the query like this ---
Like IIf([forms]![myform]![mycheck]=-1,"*" & "s" & "*") & "*"

The above only select items that have an 's' if box is checked.
 
Back
Top