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 ...
I have a ComboBox handling a foreign key selector for me. The combo box gets its item list from a foreign table's data members, has its ValueMember property set to the primary key of the foreign table ...
Results that may be inaccessible to you are currently showing.
Hide inaccessible results
Feedback