Cascading Combo Boxes using AND/OR operand (1 Viewer)

[Kyriakos]

Hey all. My case is that I have two combo boxes on a form and through the two and a command button I filter my values and get results on a new form (cascading combos). Up until now I am familiar with it. Now I want to be able when I am selecting values to leave one of the two combo boxes blank and despite that again to be able to see all the corresponding values and this should work both ways (leaving the first or the second combo empty).

Something like placing an OR operand on my stLinkCriteria command along with the AND operand which is already on.

Can this be done?
Hope I am clear enough.

 

[JamesMcS]

If I'm reading correctly you execute the filter with the command button. In the on click event of the command button, try either a select case or if statement to say "if combo box a is blank, me.filter=combo box b. if combo box b is blank, me.filter=combo box a. if both are blank, me.filteron=false".