I still don't understand need for the text fields. Why not just enter a value into number field
Have you ever done data entry? Doing math in a field is typical of accounting software. When you need to quickly split a sum into separate accounts and add sales tax at the same time, a math field can...
Go to one of the white fields, txtDebit and type 1 + 5... Enter. It's for doing calculations to set the debit amount. It works very well.
I know the footer sums work when the txtdebit and txtcredit are eliminated. That's my point. Why should they affect it in any way?
If you delete the txtDebit and txtCredit the totals work. They are text boxes for calculations. They work with an eval function. The Debit and Credit fields are not text. The sum does pull from the field and not textboxes.
The attached database has a form called frmsubCategory. It worked fine until I got fancy and put in Richard Ross' fields that calculate in the field. The pink fields should not be visible but are attached to Debit and Credit fields and totaled at the bottom.
The totals in the footer return...