Working with sub-forms

[Guest]

I've created a simple contacts db with Company, Contacts, Opportunities and
Activities tables. Relationships are Company to Contacts, Company&Contacts
to Opportunities, Company&Contacts to Activities. The main data-entry form
is a combination o fContacts, Opportunities and Activities sub-forms to the
Company form. The first two work fine but Activities do not for some reason.
Any ideas?

 

[John Vinson]

I've created a simple contacts db with Company, Contacts, Opportunities and
Activities tables. Relationships are Company to Contacts, Company&Contacts
to Opportunities, Company&Contacts to Activities. The main data-entry form
is a combination o fContacts, Opportunities and Activities sub-forms to the
Company form. The first two work fine but Activities do not for some reason.
Any ideas?

You'll need to give us a bit of help here. We cannot see your database
after all!

What is the Recordsource of the Activities subform? Please post the
SQL. Also, what are the Master and Child Link Fields? What "does not
work"? Error messages? Unable to edit or add data, or what?

John W. Vinson[MVP]
(no longer chatting for now)