Access 97 - Synchronize a combo box and text box

[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

 

[Jeff Boyce]

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.

 

[Ken Snell]

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