I have a form where users enter a client. If they enter a client name, it checks for possible duplicates. If possible duplicates exist, a popup form displays all the possible duplicates in a listbox. if the user sees the client they are adding, they dblclick on the client, to display the information on the previous form.
My problem is that I need to delete the record that is currently on the first form where they were entering in information before displaying the client that they dblclicked on. I have tried making the form the activeform then running this statement: docmd.runcommand acCmdDeleteRecord, but it won't work. I can use a dynamic sql statement and pass through some values, but I was wondering if anyone knew how I could get this to work without using a dynamic statement.