Audit Changes New Record Missing Primary Key

[dgreen]

Better that it's not failing. Issues with the current state.

NEW and DELETE actions on the taskers subform need to say that it was changed on that form. Currently it says that the f_Event main form had a new or deleted event.
The primary key # isn't getting populated in the RecordID field.
FieldName for EDITs needs to capture the original value prior to changes.

 

[theDBguy]

Hi. I was playing with it before I saw your last reply. See if you can play with the attached modified version of your db. I'll try to check it again using the new info you just provided and let you know if I have any updates after that. Cheers!

Okay, I've reset it back to use "taskauto."

 

[dgreen]

Looking at the latest version. What is the auto field doing in the t_Taskers?

FormName needs to reflect the form that the value was changed on. Currently it's picking up the main form for NEW and DELETE records.
EDIT needs to pick up the original value before the change was made.

Okay, I've reset it back to use "taskauto."

 

[dgreen]

Added in a NewValue field to the tblAuditTrail. Now capturing the new value.

How to address the NEW and DELETED records not showing the right form that the value was changed on?

 

[theDBguy]

Looking at the latest version. What is the auto field doing in the t_Taskers?

FormName needs to reflect the form that the value was changed on. Currently it's picking up the main form for NEW and DELETE records.
EDIT needs to pick up the original value before the change was made.

Hi. Please keep in mind I am not familiar with your database. So, could you please give me some step-by-step instructions on how to duplicate the problem and then tell me the actual result and what you expect as the correct result instead? Thanks.

 

[dgreen]

1) Make a change to the Taskers for an Event.

2) The change are showing in the tblAuditTrail. I'm expecting that all of the FormName values to be the subform in this case (t_Taskers subform) and not the main form. Conversely, if I made a change to the Event's Title, I'd expect the value to be f_Event in that field.

 

[theDBguy]

1) Make a change to the Taskers for an Event.
View attachment 79955
2) The change are showing in the tblAuditTrail. I'm expecting that all of the FormName values to be the subform in this case (t_Taskers subform) and not the main form. Conversely, if I made a change to the Event's Title, I'd expect the value to be f_Event in that field.
View attachment 79954

Hi. Thanks for the additional information. See if this is any closer...

 

[dgreen]

Closer. DELETE isn't picking up the value for RecordID.

 

[theDBguy]

Closer. DELETE isn't picking up the value for RecordID.
View attachment 79957

Okay. I'm on my way out the door right now. I'll check later if you still need it fixed.