Delete Record from Datasheet

[CementCarver]

I'm using Martin Greene's audit table program and have it functioning for any edits or new records with a datasheet subform inside a main form. The program is called via the BeforeUpdate event.

But when I delete a record from one of the datasheet fields, the useraction "EDIT" does not catch the delete even though it compares .oldvalue to value.

Is there another event that I should be triggered to catch deletes?

CementCarver

[RuralGuy]

Isn't there a Before Delete event?

[CementCarver]

There is, but when I associated the delete event to my module, it didn't do anything ie. tracking the delete.

CementCarver

[CementCarver]

RuralGuy,

After stepping through the code, my debug statement gives me this:

Original Fiscal Year Value is :9/20/2013
And the new one coming in is :

So, then why doesn't this line of code catch this: If FiscalYear_new <> FiscalYear_old Then ????????????
Can you do such a comparison with a null value?

CementCarver

[RuralGuy]

Nulls are strange and *never* equal to anything including another null. Try using the Nz() function to fix that.

[CementCarver]

RuralGuy, I tried this line too, but it still doesn't catch the deleted record...."If Nz(FiscalYear_new) <> Nz(FiscalYear_old) Then"

CementCarver

[RuralGuy]

How about:
If Nz(FiscalYear_new,"") <> Nz(FiscalYear_old,"") Then

[CementCarver]

Same thing happens..... it doesn't even catch the deleted record from one of the fields.

CementCarver

[RuralGuy]

I do not know Martin Greene's audit table program so I am only guessing at the problem. Sorry.

[CementCarver]

Thanks for your help anyways.... appreciate it.....CementCarver