The problem with this SQL statement is that it doesn't 'know' which
record to put into.
strPutBack = "INSERT INTO
tblAmountItems(ItemID,Amount,MyDate,Returned) " _
& "SELECT ItemID,Amount,MyDate,Returned " _
& "FROM tblOrderdetails " _
& "WHERE tblOrderdetails.Returned = True
AND tblOrderdetails.ItemID = Forms!frmOrders!frmOrderdetails!ItemID
AND tblOrderdetails.OrderID = Forms!frmOrders!OrderID;"
CurrentDb.Execute strPutBack, dbFailOnError
Now as the ItemID has been identified, it'll work OK :-)