Get rid off the other fields shows in Combobox

Dody

Registered User.
Local time
Today, 05:04
Joined
Feb 17, 2010
Messages
10
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)
 

Attachments

  • 1.jpg
    1.jpg
    24.1 KB · Views: 86
Just set the column widths property of the combo to

1";0";0";0"
 
Thank you very much....it worked perfectly I hope I have posted this 4hrs ago...;-)
 
Last edited:
Glad we could help. :)
 

Users who are viewing this thread

Back
Top Bottom