Automatically update text box

  • Thread starter Thread starter MisJ
  • Start date Start date
M

MisJ

I have a question on whether it would be possible to automatically fill a
text box with the same information when a selection is made in a combo box.

The form is currently set up:
Combo box 1: Select to filter all relevant records in the category
ie. Select Airline 1 ---> All Airline 1 records show up

A new record is generated (auto number assigned) when the next combo box is
selected
ie. Select Problem 1

I want a text box on the form to automatically show up "Airline 1" when a
new record is generated.
Is that possible?

Thanks
 
MisJ,
put an unbound textbox on your form.
Set its control source to
= Me.TheComboName.Column(1)

Note that combo columns have a zero-based numbering system.
The first column is number 0, the next 1, etc
If the airline name is the second column the above expression will work,
otherwise change the 1 to the appropriate number for the column.

Jeanette Cunningham
 
Back
Top