I want to delete records that are returned By a variable- prompt
I have this code under a procedure -CancelReservations:

Dim rec As New ADODB.Recordset
Dim Mysql As String
Mysql = "DELETE Accounts.*,Reservations.* "
Mysql = Mysql & "FROM accounts,reservations "
Mysql = Mysql & "WHERE reservations.Name
IN (" & prompt & ")"
Set rec = Cnca.Execute(Mysql)
I am getting the following error:

"Record is deleted"

how can I Avoid this error? any ideas?
hos