how to populate a form's field based on selection

[fifi]

I have a combo box with different company names. I would like all the fields
in my form to populate with the selected company's information. Example if
company a is selected, display its contact name in the contact field, email
address, address so on and so for.
Your help will be appreciated

 

[fredg]

I have a combo box with different company names. I would like all the fields
in my form to populate with the selected company's information. Example if
company a is selected, display its contact name in the contact field, email
address, address so on and so for.
Your help will be appreciated

Add a combo box to the Form Header.
Use the Combo Wizard to add the control.
Select the 3rd option on the first page of questions, something like
"Find a record .. etc."
When you select the company in that combo box, the form will fill out
with that company information.
Note: this combo box should NOT be bound to any field in the table.
Your existing combo box can be bound.

 

[fifi]

It did it. Thank you so much for your help

Add a combo box to the Form Header.
Use the Combo Wizard to add the control.
Select the 3rd option on the first page of questions, something like
"Find a record .. etc."
When you select the company in that combo box, the form will fill out
with that company information.
Note: this combo box should NOT be bound to any field in the table.
Your existing combo box can be bound.