Combobox rowsource w/ union query

[tdannay]

Hello,

I have a combobox that contains options for "Faculty", "Students", "Staff", "Other", and "(All)" via a rowsource query that looks like this:

SELECT "*" As userTypeKey, "(All)" As userType FROM userType
UNION
SELECT [userType].[userTypeKey], [userType].[userType] FROM userType;

Selecting an item from the combobox returns the records with the associated 'userTypeKey.'

What I'm curious about is whether there is a way to include an additional option in the combobox for "Faculty/Staff" that returns all of the values for both the faculty and staff. How should I approach this problem?

Thanks!