Creating a Database Audit System (1 Viewer)

I'm attempting to create a system to track changes to my database because it's going to be piloted shortly and I'm going to keep our old information systems up to date while that occurs, just in case something unexpected happens or the database is a flop.

I've tried several ways, the first worked but was too tedious, the second I got to half work, and this is the third I've tried:

vb123.com/toolshed/00_access/auditrecords.htm

However, when I follow the instructions I get run error 2465, stating that the database cannot find the field "I" referred to in the expression, this regarding:

Private Sub Form_Open(Cancel As Integer)

[txtCurrentUser] = Me.OpenArgs

End Sub

I'm hitting a brick wall here.

Any ideas?

Probably not how I'd do it, but try the load event rather than the open event.

Same problem happens.

Yeah this was the last one I tried and it seemed promising but for some reason it would copy to the temp table but not the actual audit table:

allenbrowne.com/appaudit.html

I've been able to muddle my way through VBA for everything else but I think this audit system is going to get the better of me!

Do you have a textbox/field on the form with that name?

Just in the table.

It needs to be a part of the form's record source to be able to set it that way on the form.