Grab data from record based on combo box?

[brianjessup]

Pretty basic, but I can't find this in my texts:

If a user selects from a combo box that is based on a table column, how do you store a value from another column of that same record to a variable? ie they select "Brian Jessup" from the combo box, and the value "Can't figure this out" from the same record is stored in a variable.

 

[dcx693]

Either use a Dlookup function or set the rowsource of the combo box to multiple columns so that when the user makes a selection from the box, you can pull other data from the combo box using the column property.