Running query in event procedure in Access?

Question

I have a combo box in my form with Member IDs, when I select a member ID, I want my txtLastName text box to be set to the member's name. I know what to write for the SQL query, but I don't know how to run that query and obtain the resulting name and put it into a String.

How could this be done?

Thanks

Answer 1

Access provides "out-of-the-box" solution for this without need for additional query. The idea is to use multiple columns from the combobox like this (in code):

Me.ComboBox.Column(N)

Check this out:

http://www.techrepublic.com/blog/msoffice/automatically-fill-in-access-text-boxes-based-on-a-combo-box-selection/1330