Values from combobox = txtbox

[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

 

[Jeanette Cunningham]

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

 

[roy]

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