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
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