Access 2003 component acts as if it is locked, but it doesnโ€™t

I am developing an Access 2003 form (continuous) with a combo box in the form header. This combined field has another table as the source row, which is not connected to the form's record source.

I created a combo box and set its row source to the table I need. When I click the list arrow, I see the values โ€‹โ€‹that I want in the drop-down list. I can even wash them over myself and see how they become bold. But I can not select any values. In other words, it acts as if it is locked when it is not. How to select a value in the combo box?

(If you are interested, as soon as the user selects a value, the event will open a second form based on this value)

+3
source share
1 answer

Items to check:

  • - combo box properties Enabled = Yes and Locked = No?
  • Does the form allow editing?
  • Is this a combo related to everything (Control Source property)? If so, then what?
  • try the message box or Debug.Print command from your combo. After the events of Update, On Enter and On Exit, to find out if you can understand what is happening.
+4
source

Source: https://habr.com/ru/post/1756010/


All Articles