duplicating records

J

JohnLute

I posted this in the Programming area but thought later that it's more
appropriate for this area.

I need to streamline data entry by duplicating pre-existing records. The
task is to create records for finished goods. The finished goods fall into
families of pack configurations like 2/1 GAL; 4/1 GAL; 8/.5 GAL; etc. Each
pack family has shared as wells as unique records.

What I'd like to do is create a "template" record for each pack family and
duplicate them whenever I need to create a new finished good record of the
same pack. For example: I've created "2/1 GAL" including all the shared
records. I then created a "duplicate record" button with the wizard.
unfortunately, when the button is executed the following is returned:

"Update or CancelUpdate without AddNew or Edit."

The Help button returns this:
Update or CancelUpdate without AddNew or Edit. (Error 3020)

On a Microsoft Jet database, you called the Update or CancelUpdate method
but did not use the AddNew or Edit method before writing data to a record.

On an ODBCDirect database, this error occurs when you attempt to write data
to a record without first calling AddNew or Edit.

This is all foreign to me and I'm at a loss. Any help would certainly be
appreciated!

THANKS in advance!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

duplicate record button 9
duplicating records 0
Duplicate Record Button 10
Error 2147352567 2
Me.controlname = trim(Me.controlname) 0
Updated to 2007 and... 7
Records with missing data 1
Duplicating error 2

Top