How update all records in a subform

I have a main form that has a checkbox and the onclick event of the checkbox is:

    If Me.chkbxGrowDay1Selected = True Then
       Forms!frmPlanted!subfrmReady.Form!txtReadyDate = Me.txtplantdate + Me.txtGrowDaysCalc
    End If

But when the checkbox is clicked only the first record in the subform on the main form is updated.  I need all records in the subform to update.

How do I get that to happen?  It's almost like it has to loop through the records in the subform but I don't know how to make that happen.
SteveL13Asked:
Who is Participating?
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
Either:

1. Execute an update query and then requery the form

or

2. Loop through the forms records:

 Dim rst as DAO.Recordset

Set rst = Me.RecordsetClone

If rst.Recordcount > 0 then
   rst.MoveFirst
   
   Do until rst.Eof
        ' do something
   Loop
End if

Set rst = nothing

Jim.
0
 
SteveL13Author Commented:
This worked:

 Execute an update query and then requery the form
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.