The problem is this. I have a main form with a company id (comID) and two subforms:
subContactsbyCompany and
subSubscriptionsbyCompany.
These subforms each have their own SourceObject i.e. two separate queries which link to the company ID in the main form.
Each form works individually. But I notice in design view (and in normal view when I save) that when I save the design the subforms take it in turn to switch SourceObjects. What I end up with is two subforms showing the same thing.
I've started again and recreated all elements but it just keeps happening? I tried switching off the child/parent linking and setting in sql but can't get that to work - and don't see why the correct way doens't work.
Can any body save my bacon?
subContactsbyCompany and
subSubscriptionsbyCompany.
These subforms each have their own SourceObject i.e. two separate queries which link to the company ID in the main form.
Each form works individually. But I notice in design view (and in normal view when I save) that when I save the design the subforms take it in turn to switch SourceObjects. What I end up with is two subforms showing the same thing.
I've started again and recreated all elements but it just keeps happening? I tried switching off the child/parent linking and setting in sql but can't get that to work - and don't see why the correct way doens't work.
Can any body save my bacon?