Combo Box woes

[wfoster1]

I am trying to populate 2 text boxes (firstname) & (lastname) based on the selection a user makes from a combo box. there are 2 relevant tables - ResidentData and Contacts. The Name combo box on the contacts form drops down to show all of the residents who live in the building selected by another combobox. The name combo has 3 columns
ResidentID, Firstname, lastname. the control source for the combo is the ResidentID field in the Contacts table.
When the correct resident is selected in the name combo, all that remains visible in the box is the ResidentID and not the first and last names. I would like to have 2 text boxes populated with these names so that a user can always see the person's name , not just their ID#.

Any suggestions

Thanks in advance

 

[DougP]

Have all three items in the Combo box

ID, LastName, Fisrtname

then have two text boxes "Control source" look at the following

Last name text box
=Combo1.Column(1)

First name text box
=Combo1.Column(2)

When you click the combo box any number of columns can go to any number of textboxes or other combo boxes DougP, MCP