Hi Mary
Use QBF which will work fine. But, 6 combos ?. It depends on how much data
is in the query - it may take a while to run with 6 QBF's.
Lets say you have a form (frmMarysForm) with 6 combos
cbo1
cbo2
cb3
etc
Open your query in design view
In the critiera row which has the same data as cbo1
Forms![frmMarysForm]![cbo1] Or Forms![frmMarysForm]![cbo1] Is Null
In the critiera row which has the same data as cbo2
Forms![frmMarysForm]![cbo2] Or Forms![frmMarysForm]![cbo2] Is Null
In the critiera row which has the same data as cbo3
Forms![frmMarysForm]![cbo3] Or Forms![frmMarysForm]![cbo3] Is Null
Note that access will alter this QBF when you close the query and split the
critiera into 2 columns (12 in all in your case) - so if you look at the
design again it will look a little different
Next you need to decide what you're going to do with this filter data. You
could requery your form or (beter idea, open another form with just the
filtered data), run a report, etc.etc But thats another post : - )
good luck
--
Wayne
Manchester, England.
MaryMalone said:
I have a query that has 6 combo boxes linked on a form. I want to be able to
set the criteria so that the user can pick any combination of the combo
boxes, including leaving some or all blank, and return only the values that
match. What is the easiest way to write the query without having to type out
every combination that could happen? Thoughts?
Thanks!
Mary