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 ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback