Compile Error: Argument not optional

[Nadine67]

Hello and thank your for your attention



Windows XP
Access 2007
VBA knowledge limited

I have followed Martin Green's steps (fontstuff) for creating an audit trail and am getting a compile error when I check my code.

This is my code and the error highlights 'Call AuditChanges' as the problem.

Any help would be greatly appreciated.

Private Sub Form_BeforeUpdate(Cancel As Integer)
If Not Me.NewRecord Then
Call AuditChanges("ImprovementID")
End Sub

[June7]

Need to see the code for AuditChanges sub. What arguments does it require?

Could post link to Martin Green's example code.

[orange]

Martin Green audit trail link

[Nadine67]

http://www.fontstuff.com/access/acctut21.htm

Thank you June!

I used option 3 (exclude new records) with option 4.

[June7]

If you mean Listing 4, that routine requires 2 arguments. The one you have not provided a parameter for is UserAction. The procedure differentiates between EDIT action and all others. So your call needs to be:

Call AuditChanges("ImprovementID", "EDIT")

or

Call AuditChanges("ImprovementID", "")

[Nadine67]

Hello June

Thank you very much for your help. Your 'fix' has made my audit trail work. I have done a few test runs and bravo.

Have a great day June.

Nadine