how to update fields using a combo box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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)
 
Back
Top