how to get a value from combobox

Ange

New member
Local time
Today, 12:27
Joined
Jan 26, 2008
Messages
4
Ok. this is a stupid question, but i am in a hurry and new to vba programming. I need to collect two parameters into my vba code-wanted to do it with dialog box, but thought that getting value from a form would be better - and this is the question, how do i access the value of combobox in any form?
 
From where? Another form or the same form?
MyVariable = Me.YourComboBoxName
or from another form:
MyVariable = Forms!YourFormName!YourComboBoxName
...using your form and control names of course.
 

Users who are viewing this thread

Back
Top Bottom