Get combo box selected text.

[allstar45]

Mkay, I've been working at this a while now.

I have a combo box on a form, getting information from 1 field ("name") in 1 table ("tblReferences").

in VBA I have a method on the click of a button that sets the focus to the combo box.

What I am trying to figure out is how to take the text of the reference that has been selected, and store it in a variable "courseCode"




Things I've tried:

.Value property- which just returns a number and not the text it's self
&
SQL Querie ON the Value - I cant figure out how to run, and store the RESULT of the SQL as a string.


Any tips, advice, examples, code, or tricks would be fantastic

Thanks,
-Patrick

[pbaldy]

Sounds like this:

BaldyWeb - Autofill