Subform - data not matching

[Guest]

I have a problem with my two sub-forms...

I have one main form created from two tables, then two subforms based on
other tables.

When I enter information and move onto the next record, the information in
the two subforms remains...

I don't know why this is happening. I have a field in each subform to link
to the table in the main form...!

Please help!

 

[Allen Browne]

Sounds like the linking between main form and subform is not set up
correctly.

Open the main form in design view.
Right-click the edge of the subform control, and choose Properties.
On the Data tab of the Properties box, see:
Link Master Fields
Link Child Fields

LinkMasterFields should probably be the name of the primary key of the main
form's table. LinkChildFields should be the name of the matching field in
the subform's table (i.e. the foreign key.)

 

[Guest]

Thanks heaps.
That worked

Sounds like the linking between main form and subform is not set up
correctly.

Open the main form in design view.
Right-click the edge of the subform control, and choose Properties.
On the Data tab of the Properties box, see:
Link Master Fields
Link Child Fields

LinkMasterFields should probably be the name of the primary key of the main
form's table. LinkChildFields should be the name of the matching field in
the subform's table (i.e. the foreign key.)