How to run a query based on check boxes

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Fspinelli
    New Member
    • Aug 2010
    • 85

    How to run a query based on check boxes

    Hi,

    I have to run a query based on check boxes that are checked. Only those records with a specific check box (or boxes) should come up.

    I created a form off of that query using those check boxes. If I check a box (or boxes) and run the query all records show up instead of just the records with the check box(es) checked.

    How do I make that query run only based on the check boxes checked on the form?
  • Fspinelli
    New Member
    • Aug 2010
    • 85

    #2
    I got it!

    By putting forms![name of form]![name of checkbox] in the criteria area and in the criteria row putting TRUE it works!

    Comment

    Working...