Values from combobox = txtbox

  • Thread starter Thread starter Ticotion
  • Start date Start date
T

Ticotion

Hi

I have a combo box on a form. When the user has choosen a value on the
combobox I would like a txtbox to show the txt. How do I do that?

Br

Ticotion
 
Like this-->
The textbox must be unbound.
For its control source put
=[NameOfCombo].Column(1)

Use the name of your combo where I have used NameOfCombo.

Combos start their column numbering at 0, the first column is Column(0), the
next is Column(1) and so on.

If the value you want to show in the textbox is the second column of the
combo, then you use Column(1) as in my sample line of code above.



Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia
 
Ticotion said:
Hi

I have a combo box on a form. When the user has choosen a value on the
combobox I would like a txtbox to show the txt. How do I do that?

Br

Ticotion
Click to expand...
 
Back
Top