update fields on subform when a checkbox is checked

Seasider

New member
Local time
Today, 11:59
Joined
Jan 5, 2003
Messages
33
I am new to using VBA and also to using forums but have found this one to be extremely helpful. This is my first post.

I have a form with (among other fields) four checkboxes. The form also contains a subform. The subform is used to count the checks from the checkboxes. When user checks the checkbox, the count on the subform for that checkbox should increment by 1.

It all works just fine except that the updated count(s) will only show on the subform after the form is closed and then opened again. I have attempted to solve the problem in many ways - refresh, requery, etc. but am obviously doing something wrong. Can anyone suggest a possible solution?

Thanks
 
Have you tried Me.Subformname.Requery on the AfterUpdate event of the tick box?
 
checkboxes on form

Thanks Ally

Yes, that works but it goes in the Afterupdate on the form, not the checkbox. It may also work the way you sugges but I had already found the answer.

I am new to these forums and am still learning how to search for solutions. Thanks to you and everyone else for so much help.

Cheers, Seasider
 

Users who are viewing this thread

Back
Top Bottom