combo box displaying corresponding value into textboxes issues

[technocraze]

Hi community experts,

I am encountering a problem to display the corresponding values of the combo box into the textboxes. I have chose option 1 & 3 for this implementation but neither is working. My combo box only contains distinct values, once i select the values frm that combo box, the corresponding matching the values from the combo box from the table will be displayed in the textboxes. It wont make much sense if I bound the textboxes to the controlSources. When I load the form i only can make selection from my combo box and the corresponding value is nt display on my textboxes at all. Tks

[ADezii]

Hi community experts,

I am encountering a problem to display the corresponding values of the combo box into the textboxes. I have chose option 1 & 3 for this implementation but neither is working. My combo box only contains distinct values, once i select the values frm that combo box, the corresponding matching the values from the combo box from the table will be displayed in the textboxes. It wont make much sense if I bound the textboxes to the controlSources. When I load the form i only can make selection from my combo box and the corresponding value is nt display on my textboxes at all. Tks

This is simply not enough information to work with.

[nico5038]

When your combobox recordsource holds the matching values you can use in the Combo's AfterUpdate event:

Me.txtBox1=me.comboname.column(1) ' this will move the second column !
Me.txtBox2=me.comboname.column(2) ' this will move the third column !
me.refresh

Nic;o)