Help with refreshing forms pleeeeze?

[Pennie]

I wnder if you can help. My problem is with saving records and refreshing forms.

MS Access automatically saves the record added or edited as soon as we move the insertion point to a different record. How can I make it explicitly save the data in a record while I'm still editing it? i.e. I updated field called Amount and I have a running total text control (Sum([Amount]), the only time the running total gets updated is when i move to the next record, how can I update running total as soon as I leave focus from the Amount field without having to move to the next record and back again? and without having to click Save Record on the Records menu? I'm using a form for users to update records and keep them informed of the running total.

Any help will be greatly appreciated. Thank you

 

[indesisiv]

The easiest way I think is if you use the docmd.requery.

That will recalculate the field for you.

If you put it on the update field on where it is calculated from it should do the trick.

Steve

 

[Pennie]

Thanks

Will try that. Thank you very much

 

[Fizzio]

To recalculate fields on the form, use me.recalc
To refresh the information on a form, use me.refresh
To show the new status of a control eg hidden etc, use me.repaint
To requery the information on the form eg if a parameter in the query changes, use me.requery.

To save a record at any point, use the DoCmd.RunCommand acCmdSaveRecord statement.

Hope this helps.

 

[Pennie]

Yipee!

Thank you very much,

the last one worked a treat!

To recalculate fields on the form, use me.recalc
To refresh the information on a form, use me.refresh
To show the new status of a control eg hidden etc, use me.repaint
To requery the information on the form eg if a parameter in the query changes, use me.requery.

To save a record at any point, use the DoCmd.RunCommand acCmdSaveRecord statement.

Hope this helps.