Copy Data from Main Form to Subform

[nrego]

I have a main form that populates data into table “tblCollectionTracking” and a sub form that populates data into table “tblCostRequest”. The relationship between the two tables is 1 to many. When the user clicks on the “Cost Request” button in the main form the sub form “frmCostRequestForm” opens. Can the field “Patt/SRE#” from the main form automatically populate in the sub form?

 

[nrego]

Hi Pat,

Thanks for the tips about the field name. This a database that was built by someone else and now I have to make changes. I have started to go back and rename fields to meet normalization rules.

I will try the code you gave me...