Filter results on Form using comboboxes

[farzad]

hi dear sir
I have a botton for Run a make table query .
and I have 3 combo boxs on My form that the query must filter by them and make for me a table contain this Result .
I did add this Combo boxs name on my query like
[forms].[myform].[combobox1] and 2 and 3
so , when i leave a combo box blank result must show me all item on this combo box but result is null
i want result for blank combo boxs are all item
please help me
thanks before

[dsatino]

Your query is working correctly. It wall always evaluate to Null when the combobox is Null.

What you need is a custom sub in VBA to make this work. It's not hard. How much VBA experience do you have?