audit trail question

[Davros]

Hi everyone
and yes i have looked through the audit trail threads but can't seem to find the answer. most probably simple answer but i can't find it and i'm using the module 'audittrail' which works firnd if i enter all the information or make changes through the form interface

i have a command button on a form (form called "monthly data") which automates a number of events:
1. imports an excel spreed sheet into a table called report1.
2. an append query is then triggered which appends the records to another table
3. me.requery
4. me.refresh is then run and finally
5. the form "monthly data" which is still open is now showing the new records

however in the audit trail in this form the new records which have just been appended are not showing up in the audittrail field.
anybody have any ideas why? i think it's because i have not entered the records 'through' the form interface. however i still need to have the data showing in the audittrail field
any help appreciated

 

[John Big Booty]

At a guess I think you'll need to trigger the module as step 6

 

[Davros]

tried that but did not work. i also have the audittrail module running in the beforeupdate event of the form where i trigger the update - this does not work either.
still thanks for the suggestion.
any more ideas??