Can someone explain to me why this is not working

[Darkladymelz]

I am working with Allen Browne's Audit Log and have done all tables and entered coding as stated. When I go into my form to make and edit it shows a Error Message: Debug and then my coding is shown like this:





I known nothing of coding and have just been following the instruction. I would be very grateful if someone could explain the problem to me.

[orange]

It is telling you that your program had an error and is currently stopped/paused at this liiine, and offering you a chance to do some debugging.

If you put your cursor over some variables you will see the value of those variables.

see this for more http://www.cpearson.com/excel/debug.htm

[Darkladymelz]

Ok, I will take a look at that.

I don't know how I came past the last error but I am now getting a new Error.





I'm soooooo confused!

[orange]

I see this in the Allen Browne instructions

Locate the form's AfterUpdate property. Choose [Event Procedure]. Click the Build button. Enter this line:
Call AuditEditEnd("tblInvoice", "audTmpInvoice", "audInvoice", "InvoiceID", Nz(Me!InvoiceID, 0), bWasNewRecord)

[orange]

I see this in the Allen Browne instructions == perhaps your screen shot has it, but just doesn't show the right side completely.

Locate the form's AfterUpdate property. Choose [Event Procedure]. Click the Build button. Enter this line:
Call AuditEditEnd("tblInvoice", "audTmpInvoice", "audInvoice", "InvoiceID", Nz(Me!InvoiceID, 0), bWasNewRecord)

[Darkladymelz]

The "bWasNewRecord" was included but I had not extended the window far enough.

I am not getting error messages anymore. The form is saving the changes to the record now but it is not saving the old record in the temp tables.

[orange]

What have you done to your code since you were getting errors? Something must have changed.
Did you read the stuff here re debugging
http://www.cpearson.com/excel/debug.htm