Form Delete Current Record

[kd2017]

This seems like a basic question, I apologize in advance.



I have a dialog form that needs to delete its own current record when closing IF certain criteria are met.

The data source is a table, the table has 4 currency fields, the table validation rule does not allow ALL 4 of these fields to be zero.
Table validation rule:

Not ([field1]=0 And [field2]=0 And [field3]=0 And [field4]=0)

That said, if the user attempts to *update* a record such that all 4 fields = 0, that means the record needs to be deleted all together. I attempted to do this in the From_BeforeUpdate event but was unsuccessful, what's the best way to approach this?

[Gicu]

If it made it in the table in the first place you should maybe display a warning message and set the Cancel=True in the beforeupdate instead of trying to delete it.

Cheers,
Vlad

[kd2017]

I still need to delete it.

[Gicu]

DoCmd.RunCommand acCmdDeleteRecord