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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Refresh Subform Current Record? 3
Subforms won't refresh after new record 3
Problem refreshing subform 2
refresh/requery subform 2
Multiple subforms 0
Access Main form/Subform Navigation 0
Refresh calling form 7
Refresh data in sub forms when one sub form is edited 4

Back
Top