possible to add a "select none" option to a combobox drop menu??

killyridols

Registered User.
Local time
Yesterday, 20:00
Joined
Jul 16, 2009
Messages
22
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!
 
Replace your combobox RowSource with this

Code:
SELECT YourField FROM YourTable
UNION SELECT "<Select None>" FROM YourTable;
filling in your actual field and table names.
 

Users who are viewing this thread

Back
Top Bottom