If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Adding additional value to Row source
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 |
#2
|
|||
|
|||
Adding additional value to Row source
"John" wrote in message
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 -- Dirk Goldgar, MS Access MVP www.datagnostics.com (please reply to the newsgroup) |
#3
|
|||
|
|||
Adding additional value to Row source
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/ex...tributors.html http://www.access.qbuilt.com/html/search.html __________________________________________ "John" wrote: 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 |
Thread Tools | |
Display Modes | |
|
|