Trying to read the Text in a combobox. The Value (usually an index) is available, but is not always what is needed. Sometimes we want the text.
The Text property is not available unless the control has the focus.
Here is an alternative
Run-time error '2185':
You can't reference a property or method for a control unless the control has the focus.
Read several quetions and feel that this is what people were asking for.
Did not readily find a post that puts the answer up front.
This might help the search.
Immediate Window example:
' combobox- retrieving Values
*** SEE ERROR GENERATED --->>> 2185
ND - Main Store
Note: Column(1) is a contrived value from two or more fields
msgbox "Thank You for choosing " & Me!ID_Area.Column(1), VBOKOnly, "Thanks Bonehead - for purchasing a T-Rex skull"