I am using a list box to select records to copy. I have this part working great. Now my box of rocks user (sorry he is!) say "Well what if I accidently copy the wrong ones?" So he needs a delete button. My question is, how can I code the button to delete the record from the recordset. What does the recordset.delete command do? It doesn't seem to be what I'm looking for.

Wouldn't it be easier to do aq confirmation msgbox that says are you sure you wish to copy these records into .......

If he/she then copies the wrong record(s) then they are just being stupid