Populating a combo box isn’t hard, but getting the combo box to communicate with a constantly changing list is a little more difficult. Learn how to populate your combo box with a dynamic list.
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 ...