how to populate a form's field based on selection

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

Guest

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
 
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.
 
It did it. Thank you so much for your help


fredg said:
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top