form footer SUM not working after converting to .accdb

[osupratt]

I have in the last several days converted several .mdb files to .accdb files and in all cases have struggled with calculated field such as =SUM([Quantity]*[Price]) to get a sum of all invoice detail line totals. On several the conversion worked and on several I am pulling my hair out. The form is a sub form (frmInvoice) on a main form (frmMainDataEntry). When I double click on the sub form and open up in Form View I have several thousand lines and when I scroll to the bottom the =SUM([Quantity]*[Price]) works and I can see the total of ALL the lines. However when I open up the frmMainDataEntry and enter data and move into the sub form frmInvoice and enter in several lines of data the invoice detail line totals calculate fine but the TOTAL in the sub form footer shows blank. I have spent hours on this and can't figure anything out. This database was converted .mdb to .accdb in 2007. I am opening it up the .accdb file in MS Access 2010. It was working fine as .mdb when opening with MS Access 2007. Would appreciate any help on this. Thanks.

[pbaldy]

I've seen this and I think it was a bug. If you click in the blank textbox, does it fill in? Make sure you've updated 2010, as it seems to me there was an update or patch that (allegedly) fixed this. If all else fails, and I've done this, calculate the sum programmatically and place the value there in the appropriate event(s).

[osupratt]

The value does not show up in the text box if I click in it. I am not sure what you mean by calculate programmatically? I guess I will try to create another test form in the .accdb file and see if it acts the same.

[osupratt]

I also wanted to note that when we open up the MainDataEntry form in EDIT mode the sub form shows correctly with the TOTAL in the sub form footer.

[osupratt]

I created a test form with a quantity and a price unbound text box and then one in detail for a line total. all acts as it should 5 * 5 with a line total of 25. I put SUM([quantity]*[price]) in this test form footer and it shows as blank. I am dumbfounded. What is going on?