I have a form with the default view set to Continuous forms, the form diplays a dynamic amount of records returned from a query.
The last field in the query is a check box, I want to create a button in the form footer that will check all the check boxes displayed on the form.
[Stupidly] I tried chkbox.value = true, but this only applies to the first record (form) displayed.
I guess I'm going to have to do a for each, next loop but I'm unsure what to apply this to. Can anyone help!

Thanks in advance
Ben

Ben,
  You can use the recordsetclone object if there aren't a ton of records to perform this update.

  In the click event of the button put this code

  Do while not me.recordsetclone.eof
     me.recordSetclone.Edit
     me.chkbox.value = True
     me.recordsetclone.update
     me.recordsetclone.movenext
  loop
  me.refresh

  Another alternative, faster alternative, would be to create an update SQL statement that would update all the records in a single pass. Ensure that it contains the same where clause as the recordsource for the form.

HTH,
Mike

Thanks Mike that helps a lot :)