how to update fields using a combo box

G

gm

How do I have a selection made in a combo box update fields on my form. I
have two tables, patient and network. I want to select an office from the
network and have all fields, such as, office address, phone, contact name,
etc, update once I make a selction in the "office code" combo box.
 
O

Ofer

Insert all the fields you want to be displayed in form to the RowSource
Property of the combo.
Select office, address, phone, [contact name] From network

On the after update event of the combo write the code

Me.AddressFieldName = Me.ComboName.Column(1)
Me.PhoneFieldName = Me.ComboName.Column(2)
 
Top