hello
i used allen brownes audit trail example and follwed all the instructions
but there are no recorrds being added in the audit tables. i compiled my
code but there were no errors.my form runs and i delete add and edit records
but audit table remains empty.
im using an unbound form which used DAO. and i have a custom login form
wchich gets the information from the users table.
im still relatively new at access and this is the last part i need to do
before im through with the database and its frustrating because the example
is excellent. i just don't know what im doing wrong. thankyou

"Zugz" <(E-Mail Removed)> wrote in message
newsFAD5FEF-4526-4744-A517-(E-Mail Removed)...
> hello
> i used allen brownes audit trail example and follwed all the instructions
> but there are no recorrds being added in the audit tables. i compiled my
> code but there were no errors.my form runs and i delete add and edit
> records
> but audit table remains empty.
> im using an unbound form which used DAO. and i have a custom login form
> wchich gets the information from the users table.
> im still relatively new at access and this is the last part i need to do
> before im through with the database and its frustrating because the
> example
> is excellent. i just don't know what im doing wrong. thankyou


You're using an unbound form. That code will only work with bound forms, the
events on which it depends aren't fired by unbound forms.

--
Brendan Reynolds

Thankyou so so much!! ive been suffering with this for 2 weeks now. i'l make
a bound form then try it out again.

"Brendan Reynolds" wrote:

> "Zugz" <(E-Mail Removed)> wrote in message
> newsFAD5FEF-4526-4744-A517-(E-Mail Removed)...
> > hello
> > i used allen brownes audit trail example and follwed all the instructions
> > but there are no recorrds being added in the audit tables. i compiled my
> > code but there were no errors.my form runs and i delete add and edit
> > records
> > but audit table remains empty.
> > im using an unbound form which used DAO. and i have a custom login form
> > wchich gets the information from the users table.
> > im still relatively new at access and this is the last part i need to do
> > before im through with the database and its frustrating because the
> > example
> > is excellent. i just don't know what im doing wrong. thankyou
>
>
> You're using an unbound form. That code will only work with bound forms, the
> events on which it depends aren't fired by unbound forms.
>
> --
> Brendan Reynolds
>
>