Saying form button does not create before update event??

[TenOc]

I have a subroutine that creates an audit trail when changes are made to the data on a form. This subroutine runs when the event “on current” or “before update” occurs. All works well when I move from one record to another record on the form. The problem is when I use a button to save the data on the form (without moving to a different record) or I use a button to close this form and open a different form The subroutine is not executed. I would think since the changed data is saved when either of these buttons is pressed that the on event “before update” would have occurred and the subroutine would have executed.




What I’m I missing?

[Welshgasman]

I *think*, only think that the BeforeUpdate is for bound controls? which would make more sense, as else how does Access know what goes where?

[TenOc]

I got the save button to work. Simple coding error in my Subroutine.

[Welshgasman]

I got the save button to work. Simple coding error in my Subroutine.

So what about closing the form?

[TenOc]

So what about closing the form?

I can not find any typo errors in the click close form event. The subroutine will not run when I click the close form button.

[orange]

Can you step back and tell us:
-why you want an audit trail, and
-what you want to record?

I do not understand why you would have a button to invoke an audit trail. I would expect the "audit trail records" to be done automatically when a change(add/modify/delete) occurs. Perhaps you could tell us more.

You may find this link , and the thread generally, helpful. More info on data macros

Just curious --why Win 7?

[Minty]

If the record is already saved or more importantly hasn't been edited, then when you press the button there won't be a before update event, as there is NO data update to process.

I wouldn't run an audit event on the current event, that fires just by moving between records?

[TenOc]

1. Win 7 because I have not updated my profile since 2007
2. Office LTS pro plus 2021, but can not select on the drop down selection.

The user makes a change then while still on the record (it is not saved) he clicks the close form and go to a new form button. This should trigger an audit event, but does not. Closing the from saves the change.

[orange]

I suggest you show us some code or a copy of the database with a few records and instructions to "invoke" your audit code.

[Minty]

I agree - we need to see your button code and the before update code.

[TenOc]

Instead of fighting this problem I have chosen to change the "save" button which now works (after I corrected my typo error) to a save-close old form-open new form button. This now works I think the problem is

When you close a form, the following sequence of events occurs for the form:

Unload -- Deactivate -- Close

If there are no active controls on the form, the LostFocus event occurs for the form after the Unload event but before the Deactivate event.

Thus there is NO before change event.

[Minty]

There is a Before Update event because the Unload event triggers a save if data has changed.
You can prove this very easily. In the Forms Before Update event put the following code;

MsgBox "I'm the before update event firing"

And see if it is triggered.

[orange]

What is latest status? Do you have something working that you can share with readers OR are things still not working to provide "audit trail"?

[TenOc]

See 8:34 pasting above. The work around.

[orange]

Great. But how does that relate to audit trail?

An audit trail is a series of records of computer events, about an operating system, an application, or user activities. A computer system may have several audit trails, each devoted to a particular type of activity. Auditing is a review and analysis of management, operational, and technical controls.