I have a form with two subforms (sbf1 and sbf2). Sbf1 has two purposes (1) to show each record of tutoring hours by date and (2) act as a data entry form for new tutoring hours. Both sbf1 and sbf2 are linked to the main form by StudentID. sbf2 is a form that displays the total tutoring hours.
I would like sbf2 to requery (and therefore update its total hours) as soon as a new entry is made in sbf1. I have tried to write code to requery sbf2 in the AfterUpdate property of txtTutoringHours on sbf1, but can't get it to work. sbf2 shows the correct total once the main form is closed and reopened, but I would like it to show the correct total "on the fly".
Thank you.
I would like sbf2 to requery (and therefore update its total hours) as soon as a new entry is made in sbf1. I have tried to write code to requery sbf2 in the AfterUpdate property of txtTutoringHours on sbf1, but can't get it to work. sbf2 shows the correct total once the main form is closed and reopened, but I would like it to show the correct total "on the fly".
Thank you.