Access Code to Select All Records on a Form
Posted on 2013-01-24
In Access 2010 I have a Continuous Form named frmFilter.
When I open the form, it shows some filtered records. Each record has a checkbox field named ckbComplete.
In the form header I have a command button named cmdSelectAll and I'm trying to code it to select all the records on this form.
Here's my code by code but it only selects one record which is the record that has the focus.
Dim ctl As Control
For Each ctl In Me.Controls
Select Case ctl.ControlType
ctl = True
How can this be coded to put a check in the box of all records on this form?
Thanks in advance!