Form flickers

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

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Carolyn" wrote in message
...
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.

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...


-----Original Message-----
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

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Carolyn" wrote in
message
...
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.


.

Some other causes:

Conditional formatting:
http://allenbrowne.com/bug-05.html

Unattached controls whose parent is not the form:
http://allenbrowne.com/ser-46.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

wrote in message
...
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...


-----Original Message-----
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

"Carolyn" wrote in
message
...
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.

thank you for your help.

-----Original Message-----
Some other causes:

Conditional formatting:
http://allenbrowne.com/bug-05.html

Unattached controls whose parent is not the form:
http://allenbrowne.com/ser-46.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

wrote in message
...
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...


-----Original Message-----
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

"Carolyn" wrote
in
message
...
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.


.