Form flickering

C

Carlo

I've got one form that call another form and references form1 and based on
that field it sets the other subforms to the same context.

Main form calls Second form with multuple subforms which are referenced to
the main forms one field and based on that one field set the context for the
second form and subforms. ex(=forms!main forms!field one)

I notice that if I take out the link to the parent form the flickering goes
way, how can I get around this, the main sets the field number and form 2 get
it from main form but I think its constantly checking the main form and thats
why its flickering help!!
 
A

Allen Browne

Sounds like you have Access going around in circles here. :) The solution
is to track down the cyclic dependency, and break it at some point.

For example, if you have Form1 depending on a value in Form2, when Form2
changes, Access may try to update Form1. At that time, any subforms in Form1
will be reloaded also (since the subform records depend on the main form.)
And so if Form2 is depending on any value from Form1 or its subforms, you
have it going round in circles.

If any of these references are calculated fields, then Access is
recalcuating them in this process also. So when it recalculates, anything
else that depends on the calculation will be re-triggered, and you are off
again on another cycle.

The same thing happens with conditional formatting, where the presentation
of the field is dependent on other values which are dependant on ... Well, I
think you get the point.

The idea is to temporarily remove pieces of the puzzle until you identify
where the cyclic dependency lies.
 
Top