Need to Save a Dirty Record without moving to another Record (1 Viewer)

ions

Access User
Local time
Today, 06:26
Joined
May 23, 2004
Messages
785
Dear MsAccess Expert.

I have a Taxes checkbox on my form.

The state of the checkbox is not reflected in a report unless I go to another record and go back to the original. (causing Access to save the record)

I have tried requiring the Tax Checkbox field using the afterupdate but the report is not updated.

I tried requering the entire form, which takes me to the first record.

I have tried Docmd.save and this doesn't help either.

How can I make the Report instantly reflect the Tax checkbox without having to go to another record and back?

Thank you very much.

Peter.
 

boblarson

Smeghead
Local time
Today, 06:26
Joined
Jan 12, 2001
Messages
32,059
DoCmd.Save has nothing to do with records. You can use either

DoCmd.RunCommand acCmdSaveRecord

or

If Me.Dirty Then Me.Dirty = False
 

ions

Access User
Local time
Today, 06:26
Joined
May 23, 2004
Messages
785
DoCmd.RunCommand acCmdSaveRecord

Perfect.

Thanks Bob
 

Users who are viewing this thread

Top Bottom