Save a sum from a form to a table

[jmar93]

Hi,

I'm using Access 2007 and have a form that calculates a sum from the input of 2 other boxes on the form( sheets*SqFtpers heet), I then need this sum needs to be saved to an inventory table. I know the best way would be to save the input of the boxes to the table and then do the calculation in queries and reports when I need it. The problem is that both of these inputs are not part of the table and I am hoping there is a way to accomplish this without changing the table. Is there a way to do it?

thanks,
Jeff

[Trevor2007]

use an insert query for the place in the table(for the current record) that you want to put the value:
Insert InTo [Table Name] (fieldname1,Fie ldName2, ..) & _
" Values (formfieldname, formfieldname)"