Append current object to a new table

[Amelia]

I am not real familiar with append queries. I have one set up, but I would
like it to be a little more end user friendly.

I am using Access 2007, I have an append query "Copy IS Items to Sold Items
Table." So then I have a button [Copy to Sold Items] on my Items form. For
the event on click I have an embedded macro that does the following:

OpenQuery [copy IS Item to Sold Items Table]
RunCommand [Delete Record]
RunCommand [Refresh]
OpenForm [Sold Items]

Now back to the append query "Copy IS Items to Sold Items Table" I have the
criteria set to [Tag #] so it will only add that item instead of the whole
table. I would rather have it set up so when I am on the object I want to
append to the Sold Items table, all we have to do is click the button and the
current object goes to the [Sold Items] table and the form opens to the
object that was just appended (instead of going to the first record).

So do I set this up in the append query, on the embedded macro, or on the
form. And what do I set up? I understand SQL, but not familiar with many
codes. I can follow them if I look at one, but to create my own is not really
an option yet. (I am taking a class later this year to help me out with this!)

Thanks for any help you can give me!

 

[Amelia]

Okay so I changed the form that I am opening, [Sold Items] property "on load"
to run a command refresh. And then added to the embedded macro in the [Items]
form event procedure to include a "Go To Last Record". This seems to help my
problem of opening to a the current record.

So if someone just has a solution on how to append the current record
without it prompting me for the asset #, I would appreciate it!