Delete a row

[Kenln]

I have a (sub)form. It a field is equal to a specific value I want to delete the row.

I was thinking of using Form.BeforeUpdate.
and if found set Cancel = True
and delete the row (record).

I can test for the value be how do you delete the record?

Thanks,

 

[maxmangion]

to delete a record you can use:

DoCmd.RunCommand acCmdDeleteRecord

 

[Kenln]

Works great,

Thank you,

 

[maxmangion]

you're welcome