Why didn't you recommend to the OP to iterate through all the records in his
database, selecting only those that are in the recordset his form is based
on, checking each checkbox in each selected record and then doing the
filtering? This would satisfy the OP's requirements so in your way of
thinking it would be perfectly correct. And as you say, it is a well
documented technique which you endorse.
PCD
"Bob Quintal" <rq******@sympatico.ca> wrote in message
news:Xn**********************@207.35.177.135...
Wo********@hotmail.com wrote in
news:11**********************@i40g2000cwc.googlegr oups.com:
Hello all,
I've just hit a brick wall. What I have is a form with a heap
of tick boxs and text box on it and down the bottom a subform
with shows the results. i also have a search button down the
buttom as well.
Now what I'd like to be able to do is for the user to select
and fill as many fields as they see fit then hit search and it
will show the results in the subform down the buttom that
comply to one or all of the search critea.
The trouble i'm having is with the whole optional thing in the
query.. the few thing i have tryed have just shown me null
values.
If someone could help me it would be great.
Cheers
Since we don't know what you've tried, it's kinda difficult to
suggest alternatives.
I've found that the best way is to have the query return all
records and use the filter and filterOn properties of the form
(or subform) to limit the returned results.
You will need to use code to determine which checkboxes are
checked, which textboxes have text and generate the where clause
for the filter property.
--
Bob Quintal
PA is y I've altered my email address.