Need to pull a list of data from a Combo Box Option

  • Thread starter Thread starter pgquiet
  • Start date Start date
P

pgquiet

I need to create a Combox Box that when a choice is selected all data from
another table or query relating to that choice appears. For example: A have
a combo box with a list of last names. I want to be able to choice a name
from the combo box and have all the names, and additional information that
match the last name pull back. Is a combo box the correct tool to use for
this?
 
Try this

Create a form. Place your combobox on the top of the form (cboLastName)

Put a subform on the form that shows the fields from the table you want

In the properties of the subform set the child and master link. the child
will be the LastName field in your subform.
The master will be cboLastName on your main form

When you change the lastname in the combo box the related info will show in
the subform

Tom
 
Back
Top