Hi All,
This one has me stumped. I hope someone else has seen this behavior
and knows what's going on.
I'm using Access 2003 ADP on Windows XP, database in 2002/2003 format,
with SQL Server 2000. Everything patched to latest version. This
happens both at work and at home.
My form is very similar in structure to the NorthwindCS Orders form: a
parent form with a subform in datasheet. The subform draws its data
from a view. The LinkChildFields and LinkMasterFields properties are
used to restrict the rows to what's needed for the parent values (1
field; datatype=smallint). I have a field in the footer of the subform
summing a Currency field, and a control on the parent that picks up
that value. There is no code in any important event.
The form requeries itself in an endless loop, about 5 times per
second.
Here is the kicker: if I resize the subform so all rows fit (i.e. no
vertical scrollbar), then the requery does not happen!
I can stop this behavior by taking out "=Sum([TargetAmount])" from the
ControlSource of the control in the footer of the subform. Taking out
the ControlSource of the control in the parent
(=[chiMain].[Form]![txtTargetTotal]) does not stop it.
Any insights much appreciated.
-Tom.