Hello,
I am attempting to use an append query to move one record from onetable to another. I am using the below SQL code, but when I run it I get amessage stating that 2 rows will be appended, but I only want to append thecurrent record that is being viewed on a form. FYI - The tables being...