Conditional Delete

[KevNewton29]

I want to create a button that deletes a record from a database but provided a condition is met.

I have a checking database with client insurance policies on them. For some clients there are more than one policy.

I designed a form + sub form that cycled through different policies based on the client chosen.

What I want to do is delete one of these policies if it is not needed but only if the client has more than one policy.

If he only has one policy then the client can be deleted instead (I don't this doing automatically, just a warning not would suffice)


Can anyone help?

 

[Joe4]

You should be able to create a query that has the specific criteria you want to identify which records to delete. You can then change this query to a "Delete Query", which will delete all records that meet this criteria when run.