how do add text to a drop down combobox that's using a query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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"
 
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
Click to expand...

As the combo box Rowsource, adapt the following:

Select YourTable.AField From YourTable Union Select ('ALL') from
YourTable Order by AField;
 
Back
Top