Audit Trail error

[ajm]

Hi
Ive downloaded and installed the AuditTrail zip file as mentioned in a different thread.
It works fine on my main form, but I also have a subform on that form.
I am trying to pass "ME" as a parameter to a second function ((Audit_TrailSub(Frm as form))
on the Before Update command
ie =Audit_TrailSub(ME)
However when I attempt to change a record in the subform I get a message . . .
"The object doesn't contain the automation object ME"

Anybody got any clues, please

Thanks, in advance.

ajm

 

[gemma-the-husky]

i thought me as a reserved wrd, looked like Me

therefore if you can actually see

Audit_TrailSub(ME)

in your code, you have done something wrong. Have you avctually declared a variable of some type called ME?

 

[ajm]

Me ??

Hi
I thought "me" was a reserved word - ie indicating the current object.
I've just had a look at my Before Update property on the subform and it reads
=Audit_TrailSub([Me])
MS Access has added the square brackets not . . . me (as in "ajm", the author of this posting - not the subform).

If "me" is not a reserved word, then how can I pass the form as a parameter ?

Thanks, again

ajm