View Full Version : ignoring blank checkboxes.


kokoen
02-26-2001, 04:14 AM
Hi,

I've got a form with only checkboxes, activating a query of a bunch of Y/N fields. How can I make sure Access ignores the checkboxes that weren't checked in the form? Now if I check box A, I only get the records where field A = Y and field B = 0, while I should see all records where field A = Y, regardless the value of the other fields.

How can I solve this?

llkhoutx
02-26-2001, 12:08 PM
Build and execute your query via VBA. You can't easily do what you want, if at all, with the query frame.