How to delete in Database Design

[Aldous]

I have a database with standard record function buttons. However, my 'Delete' button seems to have a problem. I am using a sql statement to search 2 tables and delete a duplicate record. However, before it will delete the record, a message box appears to confirm the deletion requiring the user to answer yes or no. I want to prevent user from deleting record if its status is "Completed" Can anyone tell me how can i achieve this.

[Dodge]

Try putting a breakpoint on your x= line (in the VBA editor click in the grey bar on the left of the editing window) and step through the code to see if something unexpected is happning; Under this role i have given delete permission for users of there own records. But while deleting ,if status of record is "Completed" then it will prevent user from deleting this record.also be sure you don't have SetWarnings set to False somewhere.

[GNom]

Use the access options which can be programmatically modified to turn off the require confirmation, The button is on a form that shows each record at a time. I originally used the wizard to create the delete button, hence the old coding. However, I did change it to the revised method. Clicking on delete button on DetailView: You need to create a custom view.detail.php which removes the delete button if the status is completed.

[Kerwin]

Clicking on delete link at the right side of line on ListView: you need to create a custom view.list.php to use a new template which does not display the delete link if its status is completed; The button works perfectly until I put the code in for the confirmation box which doesn't make any sense as I've done this everywhere else in the database with no problems at all. Try putting a breakpoint on your x= line (in the VBA editor click in the grey bar on the left of the editing window) and step through the code to see if something unexpected is happning; also be sure you don't have SetWarnings .