Combo Box Update Data

I have a table with 4 columns. Each column has different data (A,B,C,D). In a form, I have created a combo box with the values from data A. I have text boxes set up for the data in columns B, C and D. When I select one of the values in the combo box (data A), I want the corresponding values of B,C, and D to update in their text boxes. Is this possible to do within the same form?

Is the form based on the table you are looking up? In this case you want to go to the record selected. Use the third option in the combo box wizard "Find a record on my form based...."

If the form is based on a different table or query you can use a sub form to display related fields in the record.

Provided that all the columns are in the cmbobox, put the following code in the after update event

me.textBoxA = ComboBox.column(0)
me.textBoxB = ComboBox.column(1)
me.textBoxC = ComboBox.column(2)
me.textBoxD = ComboBox.column(3)



S-