Making a value from a column of a drop down list (in a form) appear into a text box

[oakhoplite]

Hi!
Can anyone tell me how to make a value from a column of a drop down list appear in a text box? For example, if I have a drop down list in a form that has 3 columns: the customerID, cutsomerfirstname and customersurname. This list contains all the customers from the customers table. When one row is selected, the text box (from the drop down list) takes the value of the customerID. I would like to do a separate text box that will take the value of customerfirstname when a row is selected from the drop down list (so to take the value of the customerfirstname column of the drop down list).

I am sorry if the explanation was not very clear. Help would be greatly appreaciated!

[isladogs]

Combobox columns are zero based so the 2nd column is column(1)

Me.txtFirstName=Me.comboboxname.Column(1)
Me.txtSurname=Me.comboboxname.Column(2)

[oakhoplite]

Thank you!