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
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