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
|
|||
|
|||
how do add text to a drop down combobox that's using a query
I have a combo box that is controled by a query. How can I add a word to
show up in the combo box along with the query. For example: 1, 2,3, All. 1-3 are selected by the query but All always shows up and never changes |
#2
|
|||
|
|||
how do add text to a drop down combobox that's using a query
One way will be, and there might be a better way
Select FieldName From TableName Union Select "All" From TableName ========================= The problem that you need a table defined, and this is why the second select include the TableName. There might be a better solution, like change the field type from number to text and add a field with value "All" -- \\// Live Long and Prosper \\// BS"D "Akilah" wrote: I have a combo box that is controled by a query. How can I add a word to show up in the combo box along with the query. For example: 1, 2,3, All. 1-3 are selected by the query but All always shows up and never changes |
#3
|
|||
|
|||
how do add text to a drop down combobox that's using a query
On Wed, 29 Mar 2006 07:57:04 -0800, Akilah wrote:
I have a combo box that is controled by a query. How can I add a word to show up in the combo box along with the query. For example: 1, 2,3, All. 1-3 are selected by the query but All always shows up and never changes As the combo box Rowsource, adapt the following: Select YourTable.AField From YourTable Union Select ('ALL') from YourTable Order by AField; -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Is Access even the right idea? | BMB | New Users | 19 | November 21st, 2005 08:01 PM |
Query for 'confirmation' | rogge | Running & Setting Up Queries | 8 | April 19th, 2005 03:26 PM |
Access reports with a horizontal line after each record??? | Bill via AccessMonster.com | Setting Up & Running Reports | 6 | March 9th, 2005 04:51 PM |
Here's a shocker | Mike Labosh | General Discussion | 2 | October 26th, 2004 05:04 PM |
Union Query Not Returning A Value | Jeff G | Running & Setting Up Queries | 2 | October 19th, 2004 05:47 PM |