Get rid off the other fields shows in Combobox

[Dody]

Hello
I need to have a Combobox with one Value to select from source table1 and populate other 3 fields from the same source table1 and STORE them in (Other) table2.
How I can get rid off the other fields shows in Combobox (see attached image)and limit it to one only. As if I change the combobox to one filed I nothing will show in the fields all though I am using :
After_change
Me.text1.value=Me.ComboBox.Column(1)
Me.text2.value=Me.ComboBox.Column(2)
Me.text3.value=Me.ComboBox.Column(3)

 

[SOS]

Just set the column widths property of the combo to

1";0";0";0"

 

[Dody]

Thank you very much....it worked perfectly I hope I have posted this 4hrs ago...;-)

 

[SOS]

Glad we could help.