Update form data after choice in Combo box.

[wbg34]

I have three text fields that get their data from a query based on the value in a Combobox. After I change the combobox value how can I get the three text fields to update?

 

[Rolliee]

Are the values you need to update part of the combo box's recordsource? If so, you could do the following at the
combo box's on_click event (or any other applicable one).

Me.text0 = me.combo0.column(1)
me.text1 = me.combo0.column(3)
me.text2 = me.combo0.column(4)

This assumes that you want to fill text0 with the second column in the combo box's recordsource - and so forth...

Rollie E