Audit Trail that works with passed through values.

[lccrews]

I'm currently using the Martin Green Audit Trail found at http://www.fontstuff.com/access/acctut21.htm. I have run into a situation where this does not work and I'm hoping someone here will be able to knock some sense into me.

I'm using a second form for editing text in text boxes that are too small on form 1 (I'm doing this vice the Shift+F2 method because the textbox provided by the system is still too small and lacks control). When I use the text editing form I use openargs to pass info back and forth from the text box on form 1 to the text editing form.

The problem is, when values are changed using the text editing form, the value passed back to form 1 isn't recorded on the audit trail.



Is there another audit trail that will work with values that are passed through from another form? I was thinking of using a table level audit trail using data macro's but I'm not sure if all that set up will work or not.

[pbaldy]

If the second form is saving the data to the table rather than passing it back to the first form, couldn't you add the audit trail code there?

[lccrews]

The second form is only passing the information back to form1 where it came from I wouldn't know how to get one form to dynamically save to different fields on a table..... Hi Paul! Thanks again for all your help!

[pbaldy]

Then I would expect the before update event of the first form to pick up the changed data. That assumes that form is bound, as is the textbox the data is put into.

Hi back! I'll be passing through LAX on my way to NZ next year.

[lccrews]

That's what I expected too, but even with the BeforeUpdate event written, the new value isn't recorded on the Audit Trail. I'm using the same BeforeUpdate event listed from www.fontstuff.com (Martin Green Audit Trail).

For example: I double click the form field I want to edit (Bl01) and the text editor pops up with the value from Bl01. When I change something and hit ok, the value passes back through to Bl01, but it doesn't look like any event is triggered. When I hit save changes and check the audit trail nothing is there. But when I make a change directly to Bl01, it works fine.

Should I post a copy of what I'm using for you to see?

[pbaldy]

Yes, that might help.

[lccrews]

Here's a copy of my database (a trimmed one).

I'm using the Form_BeforeUpdate code:

Private Sub Form_BeforeUpdate(Cancel As Integer)
    If Me.NewRecord Then
        Call AuditChanges("MBRID", "NEW")
    Else
        Call AuditChanges("MBRID", "EDIT")
    End If
End Sub

For my test, I used the Blending Tab and worked with field Bl01.

[pbaldy]

You aren't passing the value back and forth, frm_TextEditor is bound to tbl_MBR. You pass the field to bind the textbox to in OpenArgs (which I recall perhaps suggesting). Adding the audit code to that form's before update event appears to work.

[lccrews]

Paul, you did suggest this! Adding the code to the BeforeUpdate event of frm_TextEditor worked. Thanks again! Enjoy your trip to NZ! If you have a long layover, post here and I'll come buy you a drink!

[orange]

lccrews,
Is this part of this issue or something new?

[pbaldy]

Thanks again! Enjoy your trip to NZ! If you have a long layover, post here and I'll come buy you a drink!

Happy to help! We've got a daughter living there, so this will be our third trip to NZ. Unless flights change, at this point we have a layover each way, but not really long enough to leave the airport, do stuff, and then get back and go through a long security line. Thanks for the offer though! If you want cocktails at LAX, we're in!

[lccrews]

Ok Paul, just send me a message crews.landon at gmail a day or so ahead. Your drinks are on me!

Orange,
No this issue had to do with my audit trail not picking up the values that were being passed through from another form. That issue occured because I had 'audit' listed at the form level and not the control level.

[pbaldy]

What, do you live down the street or something? My brother lives in LA and he won't drive to LAX to see us.

[lccrews]

I live in Northridge (25min away). However, I'm very grateful that you've continued to help me on this project of mine. If it's after working hours, I'd like to return the favor. Plus, I ride a motorcycle, so traffic is nothing to me.