I am designing an Access 2003 form (continuous) with a combo box in the form header. This combo box has as a row source another table that is unrelated to the form's record source.
I have created the combo box and set its row source to the table i want. When I click on the combo box arrow, I see the values I want in the drop-down. I can even mouse-over them and see them turn bold. But I can't actually select any of the values. In other words, it is acting like it is locked when it isn't. How do I select a value in the combo box?
(If you're wondering, once the user selects the value, an event will open up a 2nd form based on that value)