Copy a Record in a Datasheet Subform

[Bentley]

Hello,



I am trying to copy a record in a subform in the datasheet view. I am having difficulty trying to get this set up without writing a bunch of code. Is there any info or easy way to do this? The end user cannot use the "copy""paste" buttons from the mouse as he is restricted with Runtime on his computer. I found this out after the fact....

[ranman256]

just run an append query
docmd.openquery "qaCopyRec"

uses the subform ID as the source, then append to the target table.

[Bentley]

Thanks... Do I run the code in the Query in the "Build" part? I dont want to mess up the DB as it is already in use by the team.