All - I've been searching for a couple days now, but have not had any luck finding an answer (hope I've been searching the correct forum).
Here's my question/issue.
Background
I have several queries that generate 2 tables (i.e. tblA and tblB) of normalized data.
In a form the user needs to be able to have 2 standard pivot table views off tblA and 1 standard view off tblB. All pivot table views need to be filtered on the same two criteria, which I've accomplished via dual Master/Child links. The Master/Child Links are based on comboboxes called 'CustomerName' and 'ProductFamily' and each pivot table is filtered based on these criteria.
To accomplish this, I've embedded each of the pivoted views in a tab control with 3 pages. The form nesting is as follows:
Mainform
=======
subform1 (Master Link)
========
tabCtl0 (pvtTblA child link to filter), tabCtl2 (pvt2TblA child link),. ..etc
The pivot table filters seem to update as expected, but something odd is happening when the master link is changed. Data from CustomerName1 and ProductFamily1 selection is carried over to what should be the refreshed Pivot Table view. When i look at source table (e.g. tblA) the data has actually been re-written. In testing this it seems that no matter which tab is in view, the data still seems to get re-written...has anyone encountered something like this, or perhaps see a flaw in my logic?
Thanks in advance for any advice.
Mike
P.S. I've tried searching a few times for details on this type of issue (there's alot of combination of terms) to no avail, if this has already been discussed a link would be appreciated as I may very well not have found the correct search string.
Here's my question/issue.
Background
I have several queries that generate 2 tables (i.e. tblA and tblB) of normalized data.
In a form the user needs to be able to have 2 standard pivot table views off tblA and 1 standard view off tblB. All pivot table views need to be filtered on the same two criteria, which I've accomplished via dual Master/Child links. The Master/Child Links are based on comboboxes called 'CustomerName' and 'ProductFamily' and each pivot table is filtered based on these criteria.
To accomplish this, I've embedded each of the pivoted views in a tab control with 3 pages. The form nesting is as follows:
Mainform
=======
subform1 (Master Link)
========
tabCtl0 (pvtTblA child link to filter), tabCtl2 (pvt2TblA child link),. ..etc
The pivot table filters seem to update as expected, but something odd is happening when the master link is changed. Data from CustomerName1 and ProductFamily1 selection is carried over to what should be the refreshed Pivot Table view. When i look at source table (e.g. tblA) the data has actually been re-written. In testing this it seems that no matter which tab is in view, the data still seems to get re-written...has anyone encountered something like this, or perhaps see a flaw in my logic?
Thanks in advance for any advice.
Mike
P.S. I've tried searching a few times for details on this type of issue (there's alot of combination of terms) to no avail, if this has already been discussed a link would be appreciated as I may very well not have found the correct search string.
