Adjusting Query in Form

[JasonTheAdams]

I'm trying to perform a task that I'm absolutely certain is simple to do.. if you know how to do it. I'm trying to add three check boxes in the form header to affect the query related to the form.

Each is a simple Boolean, and simply want to apply a "WHERE col1 = val1, col2 = val2, col3 = val3". Like I said, very simple.

It seemed like I could just use a Macro in the click event of the check boxes, and use a SetFilter within the macro that applies a Where Condition = [Shipped] = [chkShipped].

This... almost works. When I click the checkbox it asks for the value (it doesn't know how to process [chkShipped], which is the name of the corresponding checkbox). So that's broken, but if I provide 0 or -1, then I get the expected result.

Ideally, I would like a 3-state checkbox, but I can't even get this working. Can someone please point me in the right direction? I can tell I'm either close, or in the entirely wrong direction.

Thanks!

 

[jdraw]

Well you haven't given us much info. Could you tell us in non-Access terms WHAT you are trying to accomplish. Then tell us about your tables and relationships so we can appreciate the issue.

It isn't clear yet that your issue is with table design, relationships, forms and controls , queries or SQL generally.

 

[JasonTheAdams]

I apologize. It's a VERY simple setup.

The database has one table and one form. The table contains information for deliverables and some tracking thereof (shipped, received, etc.). The form display the contents of the table per record.

The goal is to provide the ability to filter the records by three Boolean columns (is shipped, received, and needs components). It was asked that this be a few checkboxes added to the existing form.

I believe that's enough. Please let me know if I'm forgetting something.

Thank you!