Dear June7 thank you for your reply. Problem solved. I deleted all the relations between tables and the button I made to transfer the records is now working.
I'm trying to add a button on the form to move a record from the table Not Received to the table Received. However, i have two Queries 1- qryDeleteNotReceived. 2-qryAppendReceived when I try to use them i get this message:
Kindly I need help