Subforms totals and saving them

[Joshker]

Hi All

I hope some one can come up with a good solution for this.

I have a Purchase order with lines in the sub form I've go the correct controls and calculated controls so I can display the totals.

However I need to store the totals in the Purchase order table.

I have tried several different ways to save the values.
The calculated controls are T_subtotal, T_tax, T_Total and I want to save the values in the corresponding controls Subtotal, Tax, Total.
When I does save vales if I haven't allowed time for the calculated controls to update then I end up with the incorrect values saved.

I want it to be fully automatic. so regardless of how and when the user closes the form it saves the totals I don't want to require them to have to click a button unless absolutely necessary.

Attached is a sample database.

I'm going to keep working on this my self as it seems like a no brainer But I'm getting furstrated and I'm sure someone else has tried to do this before and a new perspective will be helpfull.

Thanks

Joshker

 

[KenHigg]

As a rule of thumb, you shouldn't store this value but rather calculate it each time you need it.

 

[Joshker]

Hi Ken

Normaly I would agree But I'm building this aplication to integrate with our accounting Package So I need to save the values so they can be used elsewhere.

Thanks

Joshker

 

[KenHigg]

Can you do a query that calculates it and use the query instead of the original table? If you can get to the table you can usually get to the queries...