Problem with Subform Population

[ianacole]

I am creating a CRM Database, and have embedded an Activity History subform in the main customer entry form. My problem is this: when populating activity history in the first Main Customer entry form, the same information in the activity history populates through all Main Entry forms' subforms. In short, I guess, I want a refresh of the subforms for each main form, and the subforms to be linked to the main contact form in which the subforms were populated against. Am I making any sense?

Thanks in advance to all...

 

[jwindon]

It sounds as though you do not have the ID fields linked in your subform to your main form. A subform is joined to the value of the main form by "Child fields".

Recreate your subform using the wizard. It should ask you what field links the subform to the main form. Be sure that this field which links is displayed on both form AND subform.

 

[ianacole]

That got it, thanks. One thing that I hadn't been doing with this subform table is populating the master record number. I did that in addition to your suggestion to force a one-to-many relationship and it worked like a charm.

Thanks again for pointing me in the right direction.

Ian