Parent / Child Forms

[CTO1]

I have a parent / child relationship expressed as 2 forms but not subforms.
I want the foreign key of the child form (primary key on parent form) to automatically be entered when I insert a new record into the child form.
After scanning through FAQ's etc I have set the Form's Event Load Procedure to
=[ForeignKey]=[Forms]![ParentForm]![PrimaryKey]
I have also tried this on the Before Insert Event Procedure.

However neither seem to automatically simulate the Link Child / Master fields as in a subform.

Yours desparately

 

[Toxodont]

Could you try and set the default value of the form field to '=[ForeignKey]=[Forms]![ParentForm]![PrimaryKey]' ?

I know it may be the same thing as EventLoad, but it's worth a shot!