Combo Box

  • Thread starter Thread starter Dave
  • Start date Start date
D

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!!
 
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
 
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!!
.
Click to expand...
.
Click to expand...
 
Back
Top