Hi

I have a form built from a query. Each data on the form has a check box. I would like to have a check box and when it is checked, all the data's check boxes are checked automatically... how can I do that ? Would it be by using recordsets ?

Tx

Chantal

Yup. All bound form's in a .mdb file a bound to a native DAO recordset. Just clone that recordset in you check boxe's click event, and update the value of your Yes/No field.
(Reference the DAO library, of course).

Private Sub chkSelectAll_Click()

    Dim rst As DAO.Recordset

    ' Clone the Form's recordset
    Set rst = Me.RecordsetClone

    ' Update Yes/No field in form's
    ' underlying recordset.
    With rst
        Do Until .EOF
            .Edit
            !CheckBoxField = True
            .Update
            .MoveNext
        Loop
    End With

End Sub

HTH,

Bob

Hi,

   The easiest way to do this is to create your check all checkbox (cbxAll), and then use this code on the check box's After Update Event:

'=============================
If Me.cbxAll = -1 Then
   Me.cbxOne = -1
   Me.cbxTwo = -1
   Me.cbxThree = -1
   'etc...
End If
'==============================

   This will store the checked value in your table.

I hope this helps.


mmcdonal