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!subfrmRea
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.
If Me.chkbxGrowDay1Selected = True Then
Forms!frmPlanted!subfrmRea
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.
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Microsoft Access
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.
226K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
ASKER
Execute an update query and then requery the form