Combo Box

[Guest]

Is there a way i can get the result of the second column of a combo box to
populate a text box on the same form, without doing a dlookup?

TIA

Rico

 

[fredg]

Is there a way i can get the result of the second column of a combo box to
populate a text box on the same form, without doing a dlookup?

TIA

Rico

Two ways.

1) Set the control source of the text control to:
=[ComboName].Column(1)

or...
2) Leave the Text Control Control Source blank.
Code the AfterUpdate event of the Combo box:
[ControlName] = Me![ComboName].Column(1)

Note: Combo boxes are Zero based, so Column(1) is the 2nd column.

 

[Joe]

Thank you for the suggestion below....I was trying to populate text fields of
an order form by making a choice in the combo box in the first column of the
order form's subform. One problem,....the combo box is pulling its info from
a query and, in the combo box, it lists the four columns from the query
perfectly. However, when I make a choice, the entry that it populates to a
field called "Set Price" now has lost its formatting....for instance,...in
the query it comes up as $19.00 and in the combo box it is shown as $19.00,
however, when the text box gets populated, it comes up as 18.996.....what am
I doing wrong?
Joe

Is there a way i can get the result of the second column of a combo box to
populate a text box on the same form, without doing a dlookup?

TIA

Rico

Two ways.

1) Set the control source of the text control to:
=[ComboName].Column(1)

or...
2) Leave the Text Control Control Source blank.
Code the AfterUpdate event of the Combo box:
[ControlName] = Me![ComboName].Column(1)

Note: Combo boxes are Zero based, so Column(1) is the 2nd column.