copy locked records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Through previous discussions, I've learned how to lock a record for editing
with the exception of the fields that I want my users to enter. I also need
the ability to copy that record to a new record which I have done with a
DoCmd in VB.

If a record is locked, however, I receive only the default values in the
fields of hte new record. I would like to carry over all field values to the
new record. (Many of these fields are calculated.)

I appreciate any help you can offer.
VG
 
Sounds like you are not coping a record but just creating a blank new one.
How are you coping and pasting?
 
I have this code on the "on click" event of a command button:
' To copy the current record to a new record
DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
DoCmd.DoMenuItem acFormBar, acEditMenu, 2, , acMenuVer70
DoCmd.DoMenuItem acFormBar, acEditMenu, 5, , acMenuVer70

Thanks again for your help.
VG
 
You must log in or register to reply here.

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

Record-Locking remains open after closing 0
Record Locking 2
Locked Records 2
Turning a 3 column flat file into a "3D" Table 2
field value concatenation VBA 1
Lock field as opposed to whole record? 1
Display Warning if Record Locking 11
Lock and Unlock a form 5

Back
Top