<div>
This worked:<br />
<br />
&nbsp;Execute an update query and then requery the form
</div>


This worked:

 Execute an update query and then requery the form

<div>
<div class="content wysiwyg-content">
I have a main form that has a checkbox and the onclick event of the checkbox is:<br />
<br />
&nbsp; &nbsp; If Me.chkbxGrowDay1Selected = True Then<br />
&nbsp; &nbsp; &nbsp; &nbsp;Forms!frmPlanted!subfrmRea<wbr />dy.Form!tx<wbr />tReadyDate<wbr /> = Me.txtplantdate + Me.txtGrowDaysCalc<br />
&nbsp; &nbsp; End If<br />
<br />
But when the checkbox is clicked only the first record in the subform on the main form is updated. &nbsp;I need all records in the subform to update.<br />
<br />
How do I get that to happen? &nbsp;It's almost like it has to loop through the records in the subform but I don't know how to make that happen.
</div>
</div>


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.

How update all records in a subform

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.