Linking a field value from one form to a subform of another form

F

FA

Can someone assest me with Linking of two forms.

I have a
frmForm1 with table1 and field1.

frmForm 3 with table 2
subform frmForm2 is subform of frmForm3 with table1 and field1.

I have a cmdbutton on frmForm1 with the linkcritaria

stDocName = "frmForm3"
stLinkCriteria = "[Forms]![Subform]![frmForm2].[field1]=" & Me![field1]
DoCmd.OpenForm stDocName, , , stLinkCriteria

Its not populating the field 1 in the subform of frmForm3. I want to
populate the field1 from frmForm1 into the subform of frmForm3 called
frmForm2.

How do i achieve this?

Moe
 
Top