possible to add a "select none" option to a combobox drop menu?? (1 Viewer)

[killyridols]

Hi,
Using a combobox, I have made a drop down menu of values from a table column. When an item is selected in the combobox, records show up in a listbox.
I want to have a "select none" option in the list. Is there a way to add an entry to the combobox drop menu without altering its parent table?
thank you!

 

[missinglinq]

Replace your combobox RowSource with this

SELECT YourField FROM YourTable
UNION SELECT "<Select None>" FROM YourTable;

filling in your actual field and table names.