Hi,
I'm trying to use NeAlvey's Audit Trail code I found on this site to track changes in a database. I like the idea of having a table that stores additions, deletions, as well as edits.
If I apply the code to a form based off one table, everything works fine, but if I apply it to a form based on a query with multiple tables, I get the run time error 3251: Operation is not supported for this type of object.
I've spent a considerable amount of time searching for a solution and realize (I think) it's because of the multi-table query, but I can't seem to find a solution or at least something I understand.
I can add the error in the error trapping, but still nothing is added to the table. I've tried another example, but did not want to tag all fields needed for tracking on each form. I would really like to see this one work, if possible.
If someone can help me figure this out, I would greatly appreciate it.
Thanks in advance for any help,
Phisaw
I'm trying to use NeAlvey's Audit Trail code I found on this site to track changes in a database. I like the idea of having a table that stores additions, deletions, as well as edits.
If I apply the code to a form based off one table, everything works fine, but if I apply it to a form based on a query with multiple tables, I get the run time error 3251: Operation is not supported for this type of object.
I've spent a considerable amount of time searching for a solution and realize (I think) it's because of the multi-table query, but I can't seem to find a solution or at least something I understand.
I can add the error in the error trapping, but still nothing is added to the table. I've tried another example, but did not want to tag all fields needed for tracking on each form. I would really like to see this one work, if possible.
If someone can help me figure this out, I would greatly appreciate it.
Thanks in advance for any help,
Phisaw
