How to use a subform to add "progress reports" to main form record

[loslobo]

Can you confirm that you got your form and subform to work?

If you did, the report and subform is done exactly the same way

Yes, the form and subform seem to work. I just can't seem to find the key to getting both the main form and subform to report together.

I just need to make sure that any data I enter on the subform is linked ONLY to the specific record on the main form. Since the ID is the "link" between them I assume that this is happening.

I will check out those links you provided too.

 

[CJ_London]

I just need to make sure that any data I enter on the subform is linked ONLY to the specific record on the main form

easy to check - look at the tables

Since the ID is the "link" between them I assume that this is happening.

Providing you have made this link in the relationships window, it will do - but check as above

 

[loslobo]

I'm now making good progress on this CJ.

The problem was I didn't have a column in my subform table that helped with the link to the ID in the mainform.

Once I created a recordsource in the subform tabled called "MainFormID" and made it the child to the main form ID as parent, it all came together.

Still plugging away, and thanks so much for your patience.