Query by Form Problem

[dhersch]

I have created a database that utilizes a Query by Form. I created the unbound form and have the results tied to a query. I can get this to work properly through using "[Forms][myform][cboChosenField] or [Forms][myform][cboChosenField] is null" in the criteria.

This all works great except that I am trying to do this for many fields. . . I would estimate 10 to 12 combo boxes. I have successfully had Access allow me to query by form for 5 fields, but can't get it to work for all of them. I don't get an error message when i try, however the query doesn't work and it will not let me view it in design view.

Is there another way to accomplish this? Do I need to break the queries up into 2 or 3 separate searches? Or did I make a mistake of which I am unaware? I know that people must be programming something similar. . . Please help. . . .

 

[bat17]

It sounds like an error in your SQL if it will not let you view in Design view, I generaly build in the design view anyway as I find it easier. You dont say what the error message is but You should be able to handle 10 filters OK, The spec for Access shows 40 as the limit.

Peter