Select All Check Boxes on Continuous Form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there some VBA code that fires an event to check all checkboxes on a
continuous form if the 'Select All' check box is checked?

Thanks,
Melanie
 
Might be simplest to update them in the table, and then requery the form:

Dim strSql As String
If Me.Dirty Then
Me.Dirty = False
End If
strSql = "UPDATE [Table1] SET [MyYesNoField] = True WHERE [MyYesNoField]
= False;"
dbEngine(0)(0).Execute strSql, dbFailOnError
Me.Requery
 
Back
Top