That is why I suggested a new form be designed. Access is a very powerful tool, but in that power comes an array of options. There are many, many ways to do the same thing in Access. So any suggestion I have, may or may not be the way you would like to do it. Myself, I am very good at using the help and reading the forums. I satisfy most of my requirements using VB code, and I tend to avoid macros. Simply because in a future release, the macro can change what it does, where my code will generally always work far into the future. With code, I can control the process, with a macro, it sometimes controls me....grrr...which I do not like. One of these days, I will get stuck and ask for help, but so far, so good......
I do not know your form, but, assuming it is record based, then when you have the record you wish to delete as the active/current record, that record can be easily deleted.
Add a command button, the command button wizard should pop up. In the categories, select Record Operations, and in the Actions, Select Delete Record, on the next page ... click text and enter Delete Current Record. That should give you a quick way to delete a record.
