Subform records not refreshing

  • Thread starter Thread starter Al
  • Start date Start date
A

Al

I have a subform which shows a number of records in a
datasheet view.

When I move to the next record (in the main form) the
records in teh subform are not coming up blank
agian...they are retaining the data I entered in the main
form.

This seems weird to me and I was hoping someone coudl
offer an explanation or fix.

Thanks
A.
 
Sounds like the LinkMasterFields/LinkChildFields properties are not set
correctly.

1. Open your main form in design view.

2. Right-click the edge of the subform control, and choose Properties.

3. On the Data tab, set the LinkMasterFields property to the name of the
primary key in the main form.

4. Set the LinkChildFields property to the name of the matching foreign key
field in the subform.
 
Back
Top