Adding additional value to Row source

[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

 

[Dirk Goldgar]

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.

This link shows how to do exactly that:

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

 

[Guest]

Yep, that's one way of doing it.

How to add '(all)' to a combo box or a list box control
http://support.microsoft.com/kb/210290/en-us


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________