Running Total on Continuous Form

[Davef28]

I have a continuous form which has the following fields

Qty, Price, Ext Price

When a Qty is entered and the Enter key is pressed Ext Price is calculated Qty * Price fine. I also have a running total in the header section =sum(ExtPrice). This works fine until the last record on the form, when I press enter Ext Price is calculated but it does not update running total. What do I need to do.

Thanks

 

[Ally]

Have you tried requerying the field that needs updating on exit of the last field?

Me.FieldName.Requery

 

[Davef28]

As this is a continuous form If I requery on exit of that field it stays on same record. I need to do something to identify last record in a continuous form.

 

[Fizzio]

I'm assuming that the running sum is a calculated field. have you tried using Me.Refresh on the After_Update of the Price control?

 

[Rich]

Me.Recalc and set the cycle property to current record

 

[Davef28]

I am not sure if I have explained this very well.

The only enable field is the qty. The Price is a bound field as is the Ext Price. The qty is also bound but has to be overtyped to kick the Ext Price calculation in, which in turn should update the running sum. All the suggestions given to me do not work. Sorry.

 

[Ally]

What about, requerying OnEnter of the Qty field? That way there's nothing stopping it going into the next record.

 

[Davef28]

Still no luck, this should be so simple, perhaps one of the shortcomings of access.

 

[Rich]

On which event did you try the suggestions offered?

 

[Davef28]

Enter, Exit and After Update.

 

[Rich]

Unless you tab to a new record Access has no built in way to know that you've finished entering the quantity, set ExtPrice enabled and locked to yes use the after update of quantity. Since the tab should then take you to extprice use the GotFocus to set the focus back to quantity. You'll either have to use DoCmd save record etc. or Me.Recalc on the after update of quantity
HTH

 

[Davef28]

If I set the focus bcak to qty it only ever stays on the first record of the form. If I just tab thru I still do not get the last extprice reflected in my running total. There must be a way, but how.

Thanks to all for input so far.

 

[Rich]

Try this

 

[Davef28]

Rich, you are a star, thanks very much indeed. Have another silly problem now, see my new post. Thanks

Dave