Combo Box

[Dave]

Simple question, a combo box has a list of names from a
table in the DB, the form has fields that need to be
populated with info when I click on a name from the cbo
box. HOW DO I DO THAT?

Please help!!

 

[Damien]

One good way is to make the sure the data you want is in
the RowSource for the ComboBox.

You can then reference it on the form; eg you can set a
TextBoxes ControlSource to:

=[cmbData].Column(2)

You must make sure the column count of the ComboBox allows
for the data you want to reference, and set the Column
Widths to hide the data in the ComboBox you want to
reference elsewhere.

Let me know how you get on.


Damien

 

[Dave]

This worked great man, thank you so much!!!

-----Original Message-----
One good way is to make the sure the data you want is in
the RowSource for the ComboBox.

You can then reference it on the form; eg you can set a
TextBoxes ControlSource to:

=[cmbData].Column(2)

You must make sure the column count of the ComboBox allows
for the data you want to reference, and set the Column
Widths to hide the data in the ComboBox you want to
reference elsewhere.

Let me know how you get on.


Damien

-----Original Message-----
Simple question, a combo box has a list of names from a
table in the DB, the form has fields that need to be
populated with info when I click on a name from the cbo
box. HOW DO I DO THAT?

Please help!!
.

.