Add new record from linked form

[maxim]

Is there a way to link two forms by master and child fields so I can add new records from linked form?

 

[John Big Booty]

You mean like a Form/Sub-Form set?

 

[vbaInet]

I think the OP means linking subforms, like subform1 to subform2 for example. Maybe?

 

[maxim]

You mean like a Form/Sub-Form set?

Not exactly. I did create form and datasheet subform. In the sumborm Property Sheet on Date tab I had an option to select Maste Field and Chiled Field to link form and subform and it worked very well. But I need to enter data not from subform but from linked form.

 

[maxim]

I figured thins out

DoCmd.OpenForm "frmContacts", , , "[PlanID] = " & Me.PlanID
If IsNull(Forms!frmContacts.[PlanID]) Then
Forms!frmContacts.[PlanID] = Me.PlanID
End If