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 combo box, full of values, on a form. I would like to have one of those values selected. I tried setting the focus and using .text = "SomeValue" ...
Results that may be inaccessible to you are currently showing.
Hide inaccessible results
Feedback