2115 Error in Audit Trail

[JackSmiles]

Hi Everybody,

I have a field which is populated by an audit trail everytime I make changes to the current form, many thanks to Ghudson for that , which works fine until I actually want to add my own comments to this field.

When I add the comments and go to the next/previous form I get the following error.

2115 - The macro or function set to the BeforeUpdate or ValidationRule property for this field is preventing Login from saving the data in the field.

The code for the audit trail is set as an "Event Procedure" in BeforeUpdate.

Does anybody know a way around error message?

I'm guessing it is obviously to do with the fact that I'm editing this field but I'm not sure about how to get round this??

Many Thanks,

 

[sonny]

I use an Audit Trial feature on my main form also. I got the code from some site. It works good. But I noticed that the field required in the table does not get populated with data unless I type something in the box. I dont have that field visible on my form but just tried to enter data and close the form and reopen it, and the data typed is still there & only what I typed is now in the table.