Query for combo box

G

Guest

I have a combo box with which users choose a particular staff member. There
is a second combo that is then limited to clients of the staff member chosen
in the first combo. It all works great except for one problem: I have a
"generic" client that is used for certain types of records and I need for
this client to show up in the second combo regardless of which staff member
was chosen. Currently, this "generic" client is not assigned a staff member
at all.

Is there a way to accomplish this?

Thanks in advance!
 
J

John Spencer

Yes, you need to use a union query as the source for the second combobox.
Generically, that would look something like the query below.

SELECT "Generic" FROM CLIENTS
UNION
SELECT Client
FROM CLIENTS
WHERE Client.StaffID = Forms!Formname!ControlName
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cascading combo issue 2
Change staff assignment on the fly 6
Using a combo box as a criteria for a query 1
automatically assign value to query 1
Change staff assignment dynamically 1
Multiple Selection from a Combo Box 2
Exclude items in a query 2
How do you populate a listbox based on a combo box selection in ms access? 1

Top