Multiple comboboxes

[puakenikeni]

I'm keeping these threads separately because it's different questions I have a couple of questions.

First, In my tabbed form, I have three comboboxes. I want these three comboboxes to filter the information displayed in a subform (showing the results of a query).

The comboboxes are working properly, in a sense where the information will be displayed in the subform if it gets a "hit". However, when the three comboboxes don't produce a hit (meaning there aren't any records that contain the values displayed by the comboboxes), the subform looks weird. It'll display different values than what the comboboxes are showing--for instance, it may show another option from the third combobox, which isn't even selected. I'm afraid that this might confuse the person looking at the subform. Is there a way I can keep the subform clear when it doesn't produce a hit?

 

[wiklendt]

have you viewed the query itself to see what it is returning on its own?