Using a union query in conjunction with a filter

[jjake]

I have 3 tables

"Field"

[tblplant]
"ID"
"Plantnum"

[tblboiler]
"ID"
"boilerName"
"Plantnum" - Lookup tblplant

[tblProduction]
"ID"
"UnitName"
"PlantNum" - Lookup tblplant


I have a form with a 2 combo boxes. cboPlant. CboEquipment.

I'm using a union query to populate boilername and unitname and show both values in cboequipment.

Select tblboiler.boilername from tblboiler union select tblproduction.unitname from tblproduction

Works great. How would I combine that with a filter on cboplant so it will only show results meeting the selection?

Thanks.

 

[llkhoutx]

Add the filter to which is SELECT is appropriate.