Recalculating fields in a subform

[libraccess]

I do not even know how to explain this one, so I have attchd a (much pared down ) version
The idea is to calculate delivery costs and apportion. I know I,m trying to store calc fields in a table ( I know it's a no no)

So this works if the user is prepared to enter deliveries in the subform and then go back to the start and tab right through (not acceptable)
I have my calc controls recalc in the subform as I go but because I write the values to the table as I go through the subform once I move to the next subform record the value does not update


are you confused cause I sure am

[Bob Fitz]

I know I,m trying to store calc fields in a table ( I know it's a no no)

If you already know this, why don't you change it?

[libraccess]

I found a thousand ways that would not work, then breaking the rules I found a way that did, sort of.
The problem here is e.g. the subform has three records for the main forms one. the first record is entered and calculations occur, the second record is entered and both 1st and 2nd need to be recalculated, then the third requires the 1st and 2nd to be recalculated.
As I say if I go back to record 1 and tab all the way thru the totals are correct.

[Bob Fitz]

Can you post a copy of the db in A2003 mdb format.

[Missinglinq]

...I have my calc controls recalc in the subform as I go...

How? To recalculate derived Fields on a Form you would use simply use the Command

Me.Recalc

and a search of your code does not find this anywhere. It can be placed anywhere within the code of the Form, or Form the Subform is based on, and will re-calculate all values on that Form.

Linq ;0)>

[libraccess]

Ok I have not looked at recalc before, I have refresh and requery in my scope but have just finished reading thishttps://599cd.com/tips/access/requery-v-refresh

which is a brief but good expl. so I will give the form a rework ( there are some things in there that can go it has become a bit messy with trying a few things here and there. I will post how I go

[Missinglinq]

I think you'll find it does the job! It'll recalculate everything on the given Form, with no references to any Controls needed, and unlike Requery, it doesn't move the Record-pointer back to the beginning of the RecordSet.

Linq ;0)>