Pasteapped and copy Access 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

***note 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,

 

[SkipVought]

Hi,

There are several forums that focus on various MS Access features. You WILL get better responses, posting MS Access questions in one of these forums instead of the MS Office forum, like forum702.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}