Total Row Value Disappears After Requery

[JamesJoey]

I have a split form with a Totals row.

It works fine except on the afterupdate I requery the form.
When it requerys, the Total row value disappears until I close and then reopen the form.

The Row doesn't disappear, just the value.

Any ideas?
James

 

[isladogs]

Try these:
1. Refresh the form rather than requerying it
2. Then requery the totals field

 

[JamesJoey]

The form has records that are date specific.
The refresh works ok, as far as the Totals value disappearing.

How would I requery the Totals?

I created it on the split form using Total-Sum.

 

[isladogs]

The form has records that are date specific.
I created it on the split form using Total-Sum.

I don't use split forms & I'm unclear exactly what you mean by the above comment. Possibly:

Me.Totals.Requery

??

 

[JamesJoey]

I sort the data by date so if I change a date I need the form to reorder.

When I use Me.Totals.Requery the 'Totals' data member isn't found.

 

[isladogs]

I created it on the split form using Total-Sum.

This bit!

May be something to do with the split form design but without more info I can't suggest anything further

 

[JamesJoey]

I created a Continuous form and used Dsum on a field in the form's footer.

Works fine.

 

[isladogs]

Great.
In that case, please mark as solved!