My Audit Trail Isn't Woking

[lccrews]

I'm trying to figure out why my audit trail isn't working. When I edit a record from the form, no 'edit' record is added to tbl_AuditChanges. There are no error messages. I've attached the relevant forms from my database to see if someone can spot anything I might have done wrong. Frm_MBRSelect will ask for a parameter to open it. Please use 'C00001'. I set the library to accept 2.8 objects, I made a global module for the code, I placed the 'audit' tag, I inserted the before update event on the form, and yet nothing happens when I edit a field on the form.



I have also noticed that when all fields are blank, the code works! A record is added with action 'New'. Why doesn't it work when 'editing' current records?

[John_G]

I'm trying to figure out why my audit trail isn't working.

You'll have to give us more information than that! What does "not working" mean? You get an error message? No records are added to the table? Wrong data is added?

I can't test the database you posted - it is missing the form Frm_MBRProcess, which Frm_MBRSelect references in its record source query.

[RuralGuy]

The form Record Source is trying to look at missing Form [Forms]![Frm_MBRProcess]![Text29].

[lccrews]

I've made adjustments to my post to answer your questions. My apologies for not being clear and not providing information on how to use the form. It's linked to another form where a search box resides.

[John_G]

Your sub AuditChanges cycles through all the controls on the form looking for one with "Audit" in the tag.

The problem is - there isn't one. None of them have anything in the tag - so no record ever gets added to AuditChanges.

[lccrews]

Thank you for the help John_G... That did the trick. I thought placing 'audit' at the form level would have a trickle down effect. That wasn't the case. You're a life saver!

[orange]

lccrews,

You may get some ideas from this thread

I had issues with the Martin Green audit trail when helping PSS Margaret to deal with subforms. See post #43 in that thread for summary info.

Good luck.

[lccrews]

Thank you orange, I did find that useful. I can use that if I have to use subforms, which I may end up having to do.