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 ...

allowNewItems attribute Specify whether or not users can add to the list of items that appear in the combo box at run-time. You can also query or set this attribute ...