Hi,
I have a combobox, and when it's form opens, it is set to null. If the user selects a value from the combobox, perhaps in error, I can't figure out how to allow the value to be deleted. Each time the value is deleted, and the user tries to set focus to the next control, they are presented with the message "The text you entered isn't an item in the list.
The rowsource for the combobox is :-
Can anyone advise on how to allow the user to delete the value from this combobox and leave it empty.
Thanks in advance
I have a combobox, and when it's form opens, it is set to null. If the user selects a value from the combobox, perhaps in error, I can't figure out how to allow the value to be deleted. Each time the value is deleted, and the user tries to set focus to the next control, they are presented with the message "The text you entered isn't an item in the list.
The rowsource for the combobox is :-
Code:
SELECT DISTINCT [tblBrokerages].[ID],[tblBrokerages].[Brokerage_Name] FROM tblBrokerages ORDER BY [Brokerage_Name];
Can anyone advise on how to allow the user to delete the value from this combobox and leave it empty.
Thanks in advance