I have a main form with two subforms. Non of the forms are bound. On subform1, I have a list of items with a check box. If the user selects check marks on various items, I want the subform2 to display the items selected in subform1.
I have the following code in the Subform1 check box After Update:
Forms![Main Form]![Subform2].Requery
This works fine once I select the second check box, but the darn thing will not update the subform2 until I select the next check box. If I close the form and reopen the form then the lagging behind record is displayed, but I don't want to close the form each time. What do I need to do to have the subform2 updated as soon as I select a check box in subform1?
Thanks in advance - John
I have the following code in the Subform1 check box After Update:
Forms![Main Form]![Subform2].Requery
This works fine once I select the second check box, but the darn thing will not update the subform2 until I select the next check box. If I close the form and reopen the form then the lagging behind record is displayed, but I don't want to close the form each time. What do I need to do to have the subform2 updated as soon as I select a check box in subform1?
Thanks in advance - John
