Form flickers

  • Thread starter Thread starter Carolyn
  • Start date Start date
C

Carolyn

Is there a way to stop the flicker? I am locking or
unlocking fields on my form and subform OnCurrent based on
a certain criteria. I have it all working correctly, but
each time you move from one record to the next the form
flickers (in a very irritating manner) while it sets the
properties.
 
Several possible issues, Carolyn, but one idea that may help is to only
change the properties if they need changing.

This example test "SomeField", and it is blank than locks "AnotherField" if
is it not already locked:

Dim bLock as Boolean

bLock = IsNull(Me.SomeField)
With Me.AnotherField
If .Locked <> bLock Then
.Locked = bLock
End If
End If
 
What are the "other possible issues?" Since I have two
databases and 9 forms in each where I am setting the
locks, I'd like to find an easier way to solve the problem
if possible. Somebody suggested there is a way to "turn
off" showing an action is happening on a form...
 
Back
Top