Dear all,
i need your help in the below isssue:
in a form i have 3 different combo boxes. the values of the 2nd cb depend on the value selected from the 1st cb and the value of the 3rd cb depends on the value of the 2nd cb.

which series of criteria should i use in the query
which will run based of the values of the cb's for the below scenarios?

when i have a value in cb1 and no values in cb2 and cb3
when i have a value in cb1, a value in cb2 and no value in cb3
when all combos have values

i have tried some combination but either i got no result or a wrong result.

Many thanks in advance,
BR
Manolis