Totals don’t display on subform

[isladogs]

Remove the format from the field. It will then work fine

[Micron]

UPDATE: OK, you could add a calculated control in the form footer, which when in Split form view places the control in what looks like the header. It does produce a sum, but I see no field that relates one record to another (the form query is filtered by date and nothing else). So the calculation might need to be based on a date range. However, the form opens in Data Entry mode, which precludes the idea of seeing records, thus totals, because there's no way to even consider the use of a filter in the DSum expression ( a form that opens in Data Entry mode has no records).

It might help to know what the db and its related process is all about because table fields don't seem conducive to what I'm seeing. There's no need for a memo/long text field for such short values in the records I see. Nor should objects (e.g. table field) names use reserved words (e.g. Date). Suggesting a review of db normalization and reserved words in Access.

[Micron]

Remove the format from the field. It will then work fine

Can you reopen and check again? I did that and as I said, it worked - until it didn't.

[Emmanuel]

Interesting responses.
What really surprises me is that I have modified that same form for similar roles and had no issues.

I once again experienced this issue and I deleted and recreated a new amount textbox and the issue was fixed.

But that seems not to work here

[Emmanuel]

I kind of find a fix
I deleted all fields on the form and created new text boxes and the issue was fixed