Adding additional items to a combo list that is query based

[rich.barry]

I have a combo box with row source selecting from a query returning all employee names.
I also want two additional entries in the combo box that are not part of the employee list, e.g. Unallocated and Laboratory.
How can I add these to the combo list?

 

[Laocon]

I would say it depends on what you want to do with those other 2 criteria...

If it is for allocating a job to an employee then you would not need unallocated because an umatched query (finding jobs without employees) would give you the unallocated....

As for the Laboratory - Im not sure what you mean by this - if it refers to a group of employees then perhaps it would be best to include it in the list of employees (as LabStaff) - or include each individual and then allocate them all individually....

Or you could just add them all to the employee list (not a pretty solution) but at least they are pickable...

 

[Abby N]

You can also do it with a union query. Here's an article that will show you how.

Adding "All" to a listbox or combobox

Hope it helps.

~Abby

[This message has been edited by Abby N (edited 08-29-2001).]

 

[rich.barry]

Thanks Abby

Union works fine. I've thrown all the miscellaneous entries in a seperate table, then joined the two with a Union.
It does seem however that Mr Gates nice graphical query builder doesn't know what to think of unions, as SQL view is the only way it will display.