Combo box default value not in requery list

[JustinP]

I have a default value "Any" for a combo box that is not in the control
source (a query). When a value other than "Any" is selected from the
combo box I no longer have the option to select "Any" again. How can I
retain "Any" as an option in the combo box and still have the control
source as a query?

 

[Allen Browne]

Use a UNION query to add the "Any" option to the query's RowSource.

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

 

[JustinP]

Thanks Allen, much appreciated.

Use a UNION query to add the "Any" option to the query's RowSource.

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

 

[JustinP]

How can I make the "Any" option appear as the first record in the combo
box? (there are some records that are alphabetically before it)

 

[Allen Browne]

How about adding brackets around the Any, i.e. :
UNION ALL SELECT "(Any)" AS ...

Then include an ORDER BY clause at the end of the query to sort by this
field.