What I exactly want is that I want to transfer the selected record in a form to another table while deleting that record from the source table , can I use append query for this?
Remember the error message you received: An insert into query cannot contain a multi valued field

Since your tables contain multi-value fields, then no, you cannot use an append query to transfer complete records, i.e. copying all the fields. You could use an append query that did not contain the multi-value fields I think, but that is probably not what you want.