problems with "before update event"

[tfulmer]

Hello
I have searched the forum and have not had any luck finding a similarly related post and I hope someone can spare a moment to help out.
(I am new at this stuff so the answer may be obvious to most of you.)



I can't get a Before Update Event on a form to execute correctly in a function. The error I get is:
"The expression BeforeUpdate you entered as the event property setting produced the following error: The object doesn't contain the Automation Object 'AuditTrail' "

As part of my attempt to find out why, I opened up the mystical Northwind MDB, created an identical function, tried it out and it works fine.

I used the documenter to compare properties of the forms in my mdb versus the Northwind MDB and didn't see any big show stoppers there.

The only difference I can see is that in my mdb, On the Form properties, Event tab, Before Update line, I try to enter "AuditTrail()" and the system replaces what I type with "[AuditTrail]". In the Northwind MDB it doesn't replace what I type and keeps it as "Audit Trail()".

Does anyone have an idea if the [ ] is causing the problem and if it is what property setting do I have to change or whatever to make it work?

Thanks
Tom in a very hot Austin, Texas

[RuralGuy]

I assume you have the "AuditTrail()" code in a standard module. That module must *not* be named "AuditTrail"! Anything else would be fine.

[tfulmer]

The module is named "Module1".

[RuralGuy]

I would put =AuditTrail() in the event line. Do you have the "="?

[RuralGuy]

Does this project compile without errors?

[tfulmer]

Thanks for looking at this.

This is what I type in the event line:
"=audittrail()"

However, this is what the system automatically changes my typing to:
"=[audittrail]"

No matter what I do, I can't get the system to accept the "()" version rather than the "[]" version.

I don't get an error message during compilation, only upon execution. I posted the exact error message in the original long winded post.

[RuralGuy]

It is as if Access cannot find that function. Try *importing* your db into a fresh new db and see if the problem follows: http://www.btabdevelopment.com/ts/impnew

[tfulmer]

Good idea.

I tried it but I still have the same problem.

I will try building the entire mdb item by item and test it as I go along to see when the problem rears its ugly head.

[RuralGuy]

Use Edit>Find and see how many AuditTrail you can find.

[tfulmer]

Thank you for all of the help.

Problem solved after rebuilding from scratch.

I have no idea why the problem occurred, but it is gone.

[RuralGuy]

Some sort of corruption I'll bet. Thanks for posting back with your success.