I have a couple of "old" right-click functions that mark and un-mark record displays on a continuous form, code below. As the recordset increases in volume, the screen flicker becomes annoying. Is there a way to suppress the requery until the function(s) are complete?
Code:
Private Function SelectAll()
'========================================================================================
' Mark "ALL" records as being selected.
'========================================================================================
With Me.RecordsetClone
.MoveFirst
Do While .EOF = False
.Edit
!SelAro = ChrW(9658)
.Update
.MoveNext
Loop
End With
End Function
Public Function ClearSelects()
'========================================================================================
' Clear the selects within the current RecordSet.
'========================================================================================
Me.Recordset.FindFirst "[SelAro] = ChrW(9658)"
While Me.Recordset.NoMatch = False
Me.tbSelAro = " "
Me.Refresh
Me.Recordset.FindNext "[SelAro] = ChrW(9658)"
Wend
Me.Recordset.FindFirst "[SelAro] = Chr(32)"
End Function