I am trying to avoid flicker on the form when I run the following code where all checkboxes are set to No.
I used Appilication.Echo set to False at the beginning and set to True end. Did not help
I used Me.Visible set to False at the beginning and set to True end. There is no flicker, during the update but a major flicker at the end.
I used Appilication.Echo set to False at the beginning and set to True end. Did not help
I used Me.Visible set to False at the beginning and set to True end. There is no flicker, during the update but a major flicker at the end.
Code:
Dim rst As Recordset
Set rst = Me.RecordsetClone
rst.MoveFirst
Do While Not rst.EOF
If Nz(rst!blnNo, False) = False And Nz(rst!blnYes, False) = False Then
rst.Edit
rst!blnNo = True
rst!blnYes = False
rst.Update
End If
rst.MoveNext
Loop
Me.Dirty = False