how to reference all records in a subform?

[Sym]

quick question

I have a form with a subform. I would like a control in my parent form to uncheck a checkbox control in my subform when that field value is deleted . I can get that to work if there is only one record in my subform but it doesn't uncheck the rest. how to I reference all the records in my subform so all of them will uncheck when I delete that field value?

 

[CJ_London]

something like

 with mysubformcontrolname.form.recordset
     if not .eof then
         .movefirst
         while not .eof
              !mychkbox=false
              .movenext
         wend
     end if
 end with

 

[Sym]

thanks got it to work