In VBA for access 2000, it was really easy to prevent someone from entering a value that was not in the list. In the combobox's properties, you just change the "LIMIT TO LIST" property to ...
Pro tip: Populate an Excel UserForm combo box without VBA Your email has been sent Susan Harkins shows you two easy ways to populate an Excel UserForm, and neither requires a single bit of VBA code.
Results that may be inaccessible to you are currently showing.
Hide inaccessible results
Feedback