Text Box Populate

  • Thread starter Thread starter PieterC
  • Start date Start date
P

PieterC

I would like to have two fields in a form. One field is a
combo box with data from a table. And the other is a text
box. The text box is to be populated based on what is
entered in the combo box.

ex

Combo Box - Value {2315}
After this is selected the text box, which is blank will
be populated
Text Box - Value {Clerical Worker}

How do I get the Text box populated automatically.

Thanks
 
Hi,

First, You write a function that get combobox'value as argument and returns
populate value like

Sub Function Populate(ComboValue as Variant) as Long

Second, In textbox's Control Source property, specify =Populate(MyCombo)
(Equal sign is need).

Whenever you select item in combo box, your textbox automatically populate
value.

HTH
 
Pieter,
I guess the how depends upon why.

You can set the control source of the text box to:
=ComboName

You can code the AfterUpdate event of the Combo box:
[TextBoxName] = Me!ComboName

In both instances, I'm assuming the Combo Box bound column is the column
displayed.
If the Bound column is hidden, then use
ComboBoxName.Column(x)
where x is the column wanted.
If the column wanted is the second column, then x = 1.

Why would you want to do this, when the combo box already is showing the
data?
 
Back
Top