Delete sql statement

[Dee]

I have an Employee table with a yes/no field for "Employee Allocation".

I have an employee allocation table that stores the percent allocated, the "to department" and a comment field.

On the Employee form based off the Employee table, they can check yes for the allocation and then go to another form to enter the allocation percent etc... and this information gets stored in the employee allocation table.

I want to create a way to automatically delete the data stored in the employee allocation table if the employee allocation was changed to no.

There may be more than 1 allocation record for the employee, and I want to delete all records for that employee.

I'm thinking I would do this in the afterupdate event. I'm not too familiar with VB so not sure how to write the code. I'm using XP.

Any help would greatly be appreciated. Thank you.

 

[crosmill]

Do you have to do it in code?

The easiest way would be to create a delete query and then set the After update event to run the query.

DoCmd.OpenQuery "queryName"