Access 97 - Synchronize a combo box and text box

  • Thread starter Thread starter Darren
  • Start date Start date
D

Darren

I have a list of facilities in a combo box. Once I
select a facility I would like the address to appear in
the text box. I'm stumped any help would be greatly
appreaciated.

PS I have a very basic knowledge of Access

Darren
 
Darren

If you include the address as part of the data returned for the combo box
list, you can set the value of your text box to the address of the selection
in the combo box.

In the AfterUpdate event of the combobox, you would add something like:

Me!txtMyTextBox = Me!cboMyComboBox.Column(n)

Note that the .Column() method uses 'zero-based' numbering -- if the address
was the second column in your combobox query, you'd use .Column(1) to get
it.
 
Back
Top