copy locked records

V

VG

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
 
K

KARL DEWEY

Sounds like you are not coping a record but just creating a blank new one.
How are you coping and pasting?
 
V

VG

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
 
Top