How to duplicate a record

[katmel98]

Hi to all.

I would like to know if there is any way for create a new record that will be the exact copy of another previously created.

I mean, If I have the following record in a recordset:

LastName: Garcia
FirstName: Joe

And I want to create another exactly equal in the same recordset, how could I do that?

Thanks in advance.

Regards.

 

[DougP]

Tool bar method

Click "Edit" menu then "Select Record" then Copy
next create new record and do the same thing
Click "Edit" menu then "Select Record" then Paste

next is similar
click the gray bar to the far left of the record its the one that has a tiny black arrow on it. Then press Ctrl-C to copy the record.
Create a new record
click the same bar
and Press Ctrl-V




DougP, MCP

 

[mikeyb540]

in A2000 u can add the following to a Command Button

DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
DoCmd.DoMenuItem acFormBar, acEditMenu, 2, , acMenuVer70
DoCmd.DoMenuItem acFormBar, acEditMenu, 5, , acMenuVer70

Note: If you have a Primary Key it will freak out. There is a workaround for that but more complex.

Let me know if this helps

 

[ccburn]

You can just use the built in command button wizard by adding it to your form.