I know I have probably asked this question before. How do I get more than one column from a combo box to fill in the forms fields.

I have a form that is in a secondary table and I want the fields in the form such as: last name & Id number to be found in a lookup table and then pulled onto the form and put in the appropriate corresponding fields. That way I don't have to worry that a user is going to put the wrong Id number in for that last name.

In the AfterUpdate event for your combo box, you can simply use: Me.[TextField] = Me.ComboBox.Column(x)
Keep in mind that for multi-column combo boxes, the count starts at 0.

If you get lost, there is a lot on this under the search "populate combo column".

HTH,
David R