Sum in Form footer

[NISMOJim]

I hope this has a simple solution, but I guess I'm even simpler.



I have a database for a tire warehouse. The main table contains fields like;

TR (text) - Tire or rim
Qty (number) - Number of tires/rims in the shipment
Mfr (text) - Manufacturer
etc...

I built a query with the fields from the Inventory table, and added 2 more fields;

TireQty: IIf(([TR]="T"),[Qty],0)
RimQty: IIf(([TR]="R"),[Qty],0)

The inventory is displayed on a continuous form that has filtering options in the header. Everything is displaying correctly in the detail section of the form. The problem comes when I added 2 textboxes in the form footer to display the total amounts...

Name: txtTireTtl Control Source: =Sum([txtTireQty])
Name: txtRimTtl Control Source: =Sum([txtRimQty])

Both of these textboxes show "#Error" in Form View.

When I first did this, I swear everything was working fine. The boxes gave me a grand total of the inventory, and when I applied the filters, they gave me the correct totals of the filtered recordsets. When I came back to work the next day, all I got was the error in the boxes. I have been searching and trying different things for 3 days now, and have no idea what happened. Does anyone else out there have any insight where I should be looking? Any help will be greatly appreciated.

[NTC]

superficial first glance; you are summing ([txtTireQty])

but the record source name is defined as TireQty ....not txtTireQty

[NISMOJim]

TireQty is the name of the recordsource for the txtTireQty textbox that is in the detail section of the form. This is the textbox I want to sum in the footer.

[NTC]

have a try with: =Sum([TireQty])