Control source keeps changing
Posted on 2006-10-25
Have a problem that I have not experienced before.
There are five controls on a report; their names and datasources are
text113 =Report![Comms Crosstab]!text61
text122 =Reports![Summary Crosstab]!BasisOfCrosstabsRequirements_Crosstab.Report!Text71
text128 =Reports![Summary Crosstab]![CrosstabsDecisionAudit subreport].Report!Text71
text 124 =1-([text117]+[text113]+[text122]+[text128])
These controls work fine, all values returned correctly.
Now here's the weird thing. If I make any kind of change to text124, even a change as small as moving the control position a pixel or two, the control source for text122 and text128 changes to
and text122, text128 and text 124 then return errors. Then have to reset the source for text122 and text128 and everything is ok again. But it is really bugging. Cannot make any changes without the control sources changing then have to reset them.
Any ideas why this is happening?