Add blank entry to dropdown list

[thefourthwall]

Good morning,

Stuck on an issue that I would appreciate your help with. In a database I maintain there is a combobox called [bold]Agency[/bold] on the main form.

If the users accidentally selects an item on the list, I want the dropdown list to have a blank entry at the top that can be chosen instead. Currently the combo box is populated only by entries in tblAgency and the row source for the combobox is

SELECT tblAgency.Agency FROM tblAgency;

. I generate a report that displays records only when an item from this list has an entry from tblAgency.

I imagine that the solution is relatively easy, but after searching this forum and not finding an answer, maybe it is just not easy for me.

Your help sure is appreciated!

-thefourthwall

 

[dhookom]

Try change the Row Source query to:

SELECT tblAgency.Agency FROM tblAgency
UNION 
SELECT Null FROM tblAgency
ORDER BY 1;

Duane
Hook'D on Access
MS Access MVP

 

[Gammachaser]

Duane's solution will work quite well. I have also used something like:

Select tblAgency.Agency FROM tblAgency
UNION 
SELECT "(None)" FROM tblAgency
ORDER BY tblAgency.Agency;

because some people find selecting '(None)' more intuitive than just a blank space. The '(' will cause '(None)' to sort to the top of the list (assuming you have no other choices that start with odd characters.)