Parent/Child form relations

[Dugantrain]

I have a bound form that allows the user to enter information about a particular install team and sites that they visited. Easy enough; now what I need is a subform so that I can have a combo box where the user can choose a part and manually enter in the quantity of that particular part that the team has either gained or lost which will update the stock. What can I do so that the subform will know that its information relates to the team on the parent form? I was thinking about having an invisible text box on the child form that will automatically populate with the team # from the parent form, but I really don't know how to code this.

 

[Jack Cowley]

If you have your relationship set up in the Relationship Window between the two tables then when you add the subform to the main form Access will create the links for you. You can override this, but it should not be necessary.

hth,
Jack