Having trouble populating a field from a combo box

[Ryker7]

I have a form the contains two boxes. Social security number and name. The social security number box is a combo box that contains the two fields, social security number and name. I select the social security number I need (which populates the social security box), then exit the box. I am wanting to automatically populate the name box(name) with the corresponding name from the social security combo box. How do I do this?

 

[Poteen]

I assume you have a combobox (combo1) and a textbox (text1)

Set the name column as the bound column in combo1.

In the afterupdate event handler for combo1 put:
text1.setfocus
text1.text=combo1
text1.requery
combo1.setfocus

Cheers,
John

 

[AlienRay]

Alternatively, in the On Exit event of combo1:

Me.text1 = Me.combo1.Column(1)