syntax help in copying the previuos record

[sheela]

Hi I am new to database designing. This problem may be
very simple to most of you. But I spent couple of hours
with no success.
I will try to state my problem briefly.

I have a form to enter new records to the database. In my
database a group of records commonly has the same data,
in a number of fields in a series of records. I want to
create a command button for copying a subset of data from
previous record. Or copy data from the previous record
automatically when a new record is created.
I need the syntax help. I really appreciate any help.

Thanks in advance,
sheela

 

[Fredg]

Sheela,
To copy data from the current record into a new record,
code the command button's click event:

DoCmd.RunCommand acCmdSelectRecord
DoCmd.RunCommand acCmdCopy
DoCmd.RunCommand acCmdPasteAppend