Combo Box on form

[Juan]

Hello,
I have a form base on a table. I want to put combo box
that when I select a field from here, it fills a text box.
I can't seem to get it to work. I created the combo
Column count 4
Col widths 0";1";0";0"
ON the textbox, what should I put and where so that it
fills base on what I select on the combo box?
Or are there any good examples out there I might be able
to look at? Tried the Northwind but coudlnt' figure it out
either.
Thanks for any help you can provide.

Juan

 

[tina]

if your form is bound to a table, then bind the combo box to the appropriate
field in the table. that is, set the combo box's ControlSource to the
correct field in the underlying table.

hth

 

[Alan Fisher]

-----Original Message-----
Hello,
I have a form base on a table. I want to put combo box
that when I select a field from here, it fills a text box.
I can't seem to get it to work. I created the combo
Column count 4
Col widths 0";1";0";0"
ON the textbox, what should I put and where so that it
fills base on what I select on the combo box?
Or are there any good examples out there I might be able
to look at? Tried the Northwind but coudlnt' figure it out
either.
Thanks for any help you can provide.

Make the Text Box control source =ComboBoxName.Column(1)

The number you put in the brackets will relate to the
coulumn in your Combo Box column 0 being the first column.

 

[JUAN]

Hello Alan/tina
thanks for the help. appreciate it.

Juan