Populate subform automatically

[coyote]

Hi, I have a main form with a subform. I want to manage branch stocks. I have a table called tblProducts. All i want is once i enter the branch in the main form, then the subform is populated with the products from tblproducts, because all the branches sell the same products and entering the products manually will be so tedious. All help appreciated.

 

[RuralGuy]

If the relationship between the MainForm RecordSource and the SubForm RecordSource is set up properly, then the Link Child/MasterFields properties of the SubFormControl will do this for you with no extra programming.