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)
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)