Cascade combos with Union (ALL)

[supmktg]

I'm trying to filter a combo based on the selection in another combo.

The twist is that I need the row source of both combos to include an "*", "(All)" selection, as I am using these combos to filter a listbox. When I add the Union query with "*", "(All)", the row source in the 2nd combo is ignoring the where clause.

I've attached a sample mdb that illustrates the problem. After making a selection in the Comp combo, the Emp combo should be filtered. It works with no Union in the row source, but does not work with the Union in the row source.

Can someone help me figure this out?

Thanks,
Sup

 

[JHB]

Try it now.

 

[supmktg]

Having Order By on both sides of the Union, along with an end char( separating the 1st query from the 2nd did the trick!

Thanks so much for your help!
Sup