Access 2003 Subform behaves differently than XP Subform

  • Thread starter Thread starter JC
  • Start date Start date
J

JC

I have a database that I am converting from Access XP to
Access 2003. It uses a subform that calculated total
hours and cost on a project. In Access XP the
form/subform works fine. In Access 2003, the values on
the subform flicker when first displayed and no totals
are shown. If I minimize the form and then maximize it,
the flickering stops and the totals appear.

Does anyone have any idea of what it happening and how I
can fix it to work correctly in Access 2003?
 
Some possible causes:

1. Conditional formatting
Do any of the contorls in this subform use conditional formatting? If so,
see:
http://allenbrowne.com/bug-05.html

2. Tab control
If the subforms is on the page of a tab control, and you use Windows XP,
see:
http://allenbrowne.com/ser-46.html

3. Circular dependencies
Check the LinkMasterFields property of the subform control. Are these
calculated fields? If so, this may trigger a situation where the subform
loads records, and that causes the LinkMasterField to recalculate, which
causes the subform to reload, which ...
This can also happen if the RecordSource of the subform is being written to
programmatically, and involves a calculated field.
 
Back
Top