Lookup value based on value input

[Guest]

I have a form that has a pull down list showing "last name". The pull down
list is from a multiple column table which has "first name" in another
column. I want to add another box to my form that will automatically show
the "first name" based on the "last name" selected.

 

[Brian Bastl]

zachnjoe,

Why not simply concatenate the last name and first name together in your
rowsource and display the full name in the combobox? One less control to
fuss with.

Ex.
Select T.ID, T.LastName & ", " & T.FirstName As FullName
From MyTable T
Order By T.LastName

HTH,
Brian