Saving a form record

[KabirPatel]

Hi,

I have a Continuous Form that is bound to a table.

One of the fields in my form is editable. For each record in my form I have a report button that illustrates the data in a better format.

My problem is that when a user changes the value of the editable field and then immediately presses the report button the changed value is not immediately saved so the report shows the old value.

I have determined that the value is only saved once a user moves to another record.

Is there a way to automatically save the value of the field immediately on changing the value of the field?

Thanks
Kabir

 

[boblarson]

In the AfterUpdate event of each control you could put:

DoCmd.RunCommand acCmdSaveRecord

and that would save the record after each control has data entered.

 

[KabirPatel]

Many thanks for that - it worked a treat.