Copy a record in form view

R

ReadReadWrite

Around this time of year we're getting in lots of new editions of books we
have. For one reason or another, we often keep the old edition, so instead
of just changing the record, to show the new edition, year, authors, etc., I
have to copy the whole thing. Is there some way I can set up a control
button to copy the whole record (except the ID number), and then make those
few changes, instead of copy/pasting each field to/from the clipboard?
Thanks,
Glen
 
A

Al Camp

Glen,
The button could trigger an Append query to your table, that uses all the
values from the "from" record to a new appended record.
You can use the "from" ID to identify the data to be appended, but not
include the "from" ID in the append itself. Let the autonumber field for
the table handle that. (I'm assuming an autonumber for ID)
 
R

ReadReadWrite

Found another fix, which doesn't require a new query. It's not a
one-click-and-you're-done command button, but that's okay:
1. In Form view, select entire record (click bar that runs along the left
side).
2. Click "copy" icon.
3. Go to new/blank record.
4. Edit (menu) > Paste append.
 
Top