Originally Posted by
Kudos
Yay! Glad I could help (after leading you in fruitless circles for a bit first).
Does your After Update event still work though? You will have to pass in that parameter and if you do it within the After Update macro, it will likely overwrite the one you try to pass in from the After Delete macro, right? You'll end up with null values in the recordID again.
Yes it all seems to work now. AfterInsert,AfterUpdate pass parmRecordID=[ProjId], AfterDelete passes [Old].[ProjID].
I created record 24 and 25. Updated 25 then deleted 24. The associated log records are:
Code:
AuditID |
RecordID |
TableName |
FieldName |
ActionCode |
NewValue |
OldValue |
ChangedBy |
ChangedDate |
951 |
24 |
tblProjDemo |
projID |
CREATE |
24 |
|
mellon |
16-May-2017 11:54:50 PM |
952 |
24 |
tblProjDemo |
ProjName |
CREATE |
kudos1 |
|
mellon |
16-May-2017 11:54:50 PM |
953 |
24 |
tblProjDemo |
ProjDesc |
CREATE |
aaaaaaaaaaaaaaaaaaaaaaaaaaaaaa |
|
mellon |
16-May-2017 11:54:50 PM |
954 |
24 |
tblProjDemo |
ProjMgr |
CREATE |
aaaaaaaaa |
|
mellon |
16-May-2017 11:54:50 PM |
955 |
24 |
tblProjDemo |
ProjDueDate |
CREATE |
17-May-2017 |
|
mellon |
16-May-2017 11:54:50 PM |
956 |
24 |
tblProjDemo |
ProjEstHrs |
CREATE |
|
|
mellon |
16-May-2017 11:54:50 PM |
957 |
24 |
tblProjDemo |
ProjActualHrs |
CREATE |
|
|
mellon |
16-May-2017 11:54:50 PM |
958 |
24 |
tblProjDemo |
ProjEstHrs |
UPDATE |
2 |
|
mellon |
16-May-2017 11:54:58 PM |
959 |
24 |
tblProjDemo |
ProjActualHrs |
UPDATE |
1.4 |
|
mellon |
16-May-2017 11:54:58 PM |
960 |
25 |
tblProjDemo |
projID |
CREATE |
25 |
|
mellon |
16-May-2017 11:55:32 PM |
961 |
25 |
tblProjDemo |
ProjName |
CREATE |
kudos2 |
|
mellon |
16-May-2017 11:55:32 PM |
962 |
25 |
tblProjDemo |
ProjDesc |
CREATE |
bbbbbbbbbbbbbbbbbbbbbbb |
|
mellon |
16-May-2017 11:55:32 PM |
963 |
25 |
tblProjDemo |
ProjMgr |
CREATE |
bbbbbbb |
|
mellon |
16-May-2017 11:55:32 PM |
964 |
25 |
tblProjDemo |
ProjDueDate |
CREATE |
08-Jul-2017 |
|
mellon |
16-May-2017 11:55:32 PM |
965 |
25 |
tblProjDemo |
ProjEstHrs |
CREATE |
200 |
|
mellon |
16-May-2017 11:55:32 PM |
966 |
25 |
tblProjDemo |
ProjActualHrs |
CREATE |
0 |
|
mellon |
16-May-2017 11:55:32 PM |
967 |
25 |
tblProjDemo |
ProjDesc |
UPDATE |
bbbbbbbbbbcccc |
bbbbbbbbbbbbbbbbbbbbbbb |
mellon |
16-May-2017 11:55:48 PM |
968 |
25 |
tblProjDemo |
ProjDueDate |
UPDATE |
20-Jul-2017 |
08-Jul-2017 |
mellon |
16-May-2017 11:55:48 PM |
969 |
25 |
tblProjDemo |
ProjDueDate |
UPDATE |
11-Jul-2017 |
20-Jul-2017 |
mellon |
16-May-2017 11:56:00 PM |
970 |
25 |
tblProjDemo |
ProjEstHrs |
UPDATE |
205 |
200 |
mellon |
16-May-2017 11:56:00 PM |
971 |
24 |
tblProjDemo |
projID |
DELETE |
|
24 |
mellon |
16-May-2017 11:56:17 PM |
972 |
24 |
tblProjDemo |
ProjName |
DELETE |
|
kudos1 |
mellon |
16-May-2017 11:56:17 PM |
973 |
24 |
tblProjDemo |
ProjDesc |
DELETE |
|
aaaaaaaaaaaaaaaaaaaaaaaaaaaaaa |
mellon |
16-May-2017 11:56:17 PM |
974 |
24 |
tblProjDemo |
ProjMgr |
DELETE |
|
aaaaaaaaa |
mellon |
16-May-2017 11:56:17 PM |
975 |
24 |
tblProjDemo |
ProjDueDate |
DELETE |
|
17-May-2017 |
mellon |
16-May-2017 11:56:17 PM |
976 |
24 |
tblProjDemo |
ProjEstHrs |
DELETE |
|
2 |
mellon |
16-May-2017 11:56:17 PM |
977 |
24 |
tblProjDemo |
ProjActualHrs |
DELETE |
|
1.4 |
mellon |
16-May-2017 11:56:17 PM |