Creating a filter for a list box

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
 
K

KARL DEWEY

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help creating a search form in Access XP 0
Possible to Combine reports to's to a single box? 0
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
Problems created by Recent updates to Outlook 365 0
Populate a table based on check box status 2
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Filtering and summing a calculated field on a subform 0
Using a Combo Box for Filtering a Continous Form 2

Top