If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Need to pull a list of data from a Combo Box Option
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? |
#2
|
|||
|
|||
Need to pull a list of data from a Combo Box Option
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 "pgquiet" wrote in message ... 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? |
Thread Tools | |
Display Modes | |
|
|