Adding additional value to Row source

J

John

Hi

I have a query as a rowsource to a list. Is it possible to add a single
additional value to the row source to appear in the list in addition to what
is coming from the query? Such as by union of the query with the fixed
value?

The reason I need is that I have several values coming from the query but I
also need to add 'ALL' in the list for user to select which is not coming
from the query.

Thanks

Regards
 
D

Dirk Goldgar

John said:
Hi

I have a query as a rowsource to a list. Is it possible to add a
single additional value to the row source to appear in the list in
addition to what is coming from the query? Such as by union of the
query with the fixed value?

The reason I need is that I have several values coming from the query
but I also need to add 'ALL' in the list for user to select which is
not coming from the query.
Click to expand...

This link shows how to do exactly that:

http://www.mvps.org/access/forms/frm0043.htm
Forms: Adding "All" to a listbox or combobox
 
Top