I have a text box located on the main form. I would like to requery the total given in the text box (based on a query) on the AfterUpdate event of a subform. I have a second subform that uses the same query and can get it to update fine, but the text box will requery the entire form. This would not be a problem, but the user can enter time for previous days, and therefore the requery moves the previous days records to the chronological order.

The short, is on an AfterUpdate event on the subform, how can I requery just the text box on the main form?

Thanks in advance