Select All Check Boxes on Continuous Form

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
 
A

Allen Browne

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

select all for check box.. 3
"Select All" control in continuous form 17
Unbound Controls on Continuous Forms 1
Run a form in background using checkboxes on main form 0
Using Check Boxes to select items in an Access subform. 0
checkbox - strange behavior 2
subform: event that fires for every record 2
One Check box to check all check boxes 2

Top