Continous form not updating text box

[Georgina]

Hi

I have a continuous sub form linked to a main form.

The fields on the subform are:

Quantity
Part Number
Description
Code
Price

I also have a total price field for each record the control source for this is
=[Quantity]*[Unit Price].

I then have a text field to calculate the order total in the form footer control source is
=Sum([Total Price]).

The problem that I have is if I change the quantity in record 1, the text field to calculate the order total does not update until I tab onto record 2.

Have searched far and wide for the answer and have tried all manner of me.[mytextboxname].requery to no avail - help!

Thanks

Georgina

 

[Rich]

Me.Recalc although you should save the record first

 

[Georgina]

You wouldn't beleive how long I had been looking for that answer! - Thanks very much for your help

 

[tommyboy]

I have a problem that is the same. Where do you enter this me.recalc

 

[Pat Hartman]

You need to save the record. The Sum() looks at the recordset. If you havent saved the current record, it is not reflected in the recordset.

DoCmd.RunCommand acCmdSaveRecord

 

[Georgina]

Hi

If you put the code that Pat has suggested in the after update propoerty of the field that could change that will work.

In my case, the 2 fields that a user may change were Quantity and Unit Price

George