#errror in calculated control on main form

[marcenmoni]

I have an unbound main form, with a subform linked to a query. In the subform footer I have two calculated controls, each summing different fields shown in the subform. When I load the subform, the calculated controls work fine.

When I load the main form, the unbound controls on the main form that refer to the subform also work fine. However, when I use this code to add a record to the table on which the query is based, and do a requery to update it

Rset3.AddNew
Rset3!jpegID = Rset4!jpegID
jpegcheck = Me!jpegno01
Rset3!lotID = Rset4!lotID
Rset3!Status = "first"
Rset3.Update
Rset4.Close
Me.templot.SourceObject = "query.Jpegcombinetemp"


I get an #error in the controls on the main form. If I close the main form and reopen it, the controls show up fine, (with the new totals).

Do I need to do the requery in a different way?

Thanks.

Marcello