PasteAppend and Copy no longer works in 2007

[kiki2]

I am trying to update a macro which used copy and pasteappend from a previous versions. After data was entered into a form this macro captured that single item and updated a new table. Access 2007 does not recognize these commands, here is an example of macro:
RunCommand SelectRecord
RunCommand Copy**
OpenTable TableName
RunCommand PasteAppend**
Close

*** not read by access 2007

I think creating an append query would solve my problem with an OpenQuery macro. When I used this, I created thousands of records instead of one, and I can understand what I did wrong.

OpenQuery queryname of appendquery
Close same

Thanks,

 

[dhookom]

I expect you can use the append query but you need to grab the primary key value from the selected record.

Duane
Hook'D on Access
MS Access MVP