Access 97 - Synchronize a combo box and text box

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.

--
Good luck

Jeff Boyce
Access MVP

See The ACCESS Web:
http://www.mvps.org/access/forms/frm0058.htm


--

Ken Snell
MS ACCESS MVP

"Jeff Boyce" -DISCARD_HYPHEN_TO_END wrote in message
...
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.

--
Good luck

Jeff Boyce
Access MVP