P
PNeely
Guest
Hi
I'm new to Access and can't seem to find an answer to this one, though I know it's a basic question for most of you.
I'd like to create a form with a combobox that updates the contents of a subform. For example, I'd like to show all the items sold by a particular company; I would select the company from the combobox and the subform would display all items sold by that company. It would also allow me to enter new items for that company.
So far, I have created a Companies table and an Items table, but I'm not sure which one to link the main form to. I presume I link the main form to tbl_Companies and the subform to tbl_Items, but even after specifying which is the parent field and which is the child field, I can't get the subform to update when I select a company from the combobox. The subform just displays the same contents no matter what company I choose.
I think it's not just the form/subform I need help with; I think I also might need guidance about how to structure the tables and any required queries properly. It would help if any of you could point me towards a sample database I could look at which illustrates the above elements, but I think I also need some walking through, if that's possible.
I've got a book about Access which included subforms, but it's description wasn't detailed enough.
Many thanks in advance
Pete
I'm new to Access and can't seem to find an answer to this one, though I know it's a basic question for most of you.
I'd like to create a form with a combobox that updates the contents of a subform. For example, I'd like to show all the items sold by a particular company; I would select the company from the combobox and the subform would display all items sold by that company. It would also allow me to enter new items for that company.
So far, I have created a Companies table and an Items table, but I'm not sure which one to link the main form to. I presume I link the main form to tbl_Companies and the subform to tbl_Items, but even after specifying which is the parent field and which is the child field, I can't get the subform to update when I select a company from the combobox. The subform just displays the same contents no matter what company I choose.
I think it's not just the form/subform I need help with; I think I also might need guidance about how to structure the tables and any required queries properly. It would help if any of you could point me towards a sample database I could look at which illustrates the above elements, but I think I also need some walking through, if that's possible.
I've got a book about Access which included subforms, but it's description wasn't detailed enough.
Many thanks in advance
Pete
