Hi all,
A have a strange problem from couple of days ago.
I have a main form and subform (Continuous Form) that has a Textbox in Form footer that Sums one of the fields on the form (Total field = QTY x Price).
It stopped working just like that.
I also have an older backup of the same subform with the same field names, same record source that works just fine when I put it on same main form.
One more strange thing is that I created a new test Subform with just 3 fields and it also wont work but the backup works fine.
I am using Microsoft® Access® 2021 MSO (Version 2205 Build 16.0.15225.20028) 32-bit with SQL Server as backend
And one more thing - SUM field works when I add a new record or delete a record and on Requery but when I change the price or quantity for example it wont refresh. And not just that but all summary fields wont refresh on record edit on current and new form but work just fine on backup form.
Current form
Backup form
New test form
I tried deleting all the code from the form as i dont need it for this operation but it makes no difference.
I tried repairing Office, updating Windows and Office, Decompiling and repairing database, exporting form to text file and importing it back - nothing worked.
Do you have any ideas what might be the problem ?
A have a strange problem from couple of days ago.
I have a main form and subform (Continuous Form) that has a Textbox in Form footer that Sums one of the fields on the form (Total field = QTY x Price).
It stopped working just like that.
I also have an older backup of the same subform with the same field names, same record source that works just fine when I put it on same main form.
One more strange thing is that I created a new test Subform with just 3 fields and it also wont work but the backup works fine.
I am using Microsoft® Access® 2021 MSO (Version 2205 Build 16.0.15225.20028) 32-bit with SQL Server as backend
And one more thing - SUM field works when I add a new record or delete a record and on Requery but when I change the price or quantity for example it wont refresh. And not just that but all summary fields wont refresh on record edit on current and new form but work just fine on backup form.
Current form
Backup form
New test form
I tried deleting all the code from the form as i dont need it for this operation but it makes no difference.
I tried repairing Office, updating Windows and Office, Decompiling and repairing database, exporting form to text file and importing it back - nothing worked.
Do you have any ideas what might be the problem ?