Sub Form - Continuous

[PShiers]

I have a form, which has a subform, which is a continuous form. In the footer of the subform it sums the costs and then the main form displays the sum. Pretty basic stuff

1. When the user changes a cost or enters a cost is does not change the sum on the footer until the record if complete and a new record started.

2. So have added me.requery on Cost.AfterUpdate, but the focus jump to the first field of the first record.

Is there a way of solving point 1. without have to do requery or is there way to get the focus back to the current record after requery.

Thanks

 

[boblarson]

You don't need to add the requery. But in the After Update event put:

If Me.Dirty Then Me.Dirty = False

which will save the record at that point and then the totals should update.