I am working on a Budget form (that someone else created), that is built of a Budget table. Unfortunately, the original designer did not feel that it was necessary to make the total field accessable in forms. The Verticle axis of the report displays Expense Codes and the Horizontal displays broken down catagories. The fields with in the cross table update with no problem, but the Cost code totals (vertical right) and the break down totals (bottom) are not entered back into the table. They are simply calculations bearing the names of total fields in the table.

Is there a way to create a link from the Total fields in the form, back to the table???

I feel like I have tried everything short of starting from scratch.

Since the totals fields are calculated values you should not store them in a table, nor should it be neccessary. If the totals are showing on the report add calculated fields of the same type to the form(s).

Recalculating the fields for the report wouldn't be a whole lot of fun because I only need the grand total off all 120 fields. This Grand total field along with the catagorical fields would be very helpful to use in reports, but I'm unable to access it because it does not update in the table. Each of the total calculations has it's own field in the table already. I really need to get it to update or fill in the table with the totals.