Looping through subform records in code? 1

[markgx]

I have a datasheet subform on a main form. The subform records have tick box fields. When a subform tickbox is ticked, (the on click event), I want to check all other records in the subform to see if all tick boxes have been ticked, and then update the main form header record accordingly. I am using Access 2002 and ADO 2.1

Thanks Mark Greatorex

 

[KenReay]

Hi

In the after update event of the tickbox control on the subform

Dim Rs as ADODB.Recordset

If chkBox = True Then
Set Rs = Me.RecordsetClone
Do Until Rs.EOF
' do your checking here
Rs.MoveNExt
Loop
Rs.Close
Set Rs = Nothing
End if Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[markgx]

Thanks,
My problem seemd to be that I didn't know what to define the record set as - DAO ADO etc.

The line
dim rs asADODB.Recordset
was the important one.

Thanks
Mark.