Paste/Append isn't available

  • Thread starter Thread starter Pat
  • Start date Start date
P

Pat

Hi. I have a command button established to duplicate a
record in my subform. I click in the row of the record I
wish to duplicate, click the command button, and get error
message "The command or action "PasteAppend" isn't
available now."

I think this may be because I have the Allow Additions
property set to No for the form because I want to force
users to click the Add Record button in order to add a new
record; this feature is working fine after I put
Me.AllowAdditions = True in as an event procedure. Is
there a similar line of code that I need to put in the
DupRecord procedure?

Thanks!
Pat
 
-----Original Message-----
Hi. I have a command button established to duplicate a
record in my subform. I click in the row of the record I
wish to duplicate, click the command button, and get error
message "The command or action "PasteAppend" isn't
available now."

I think this may be because I have the Allow Additions
property set to No for the form because I want to force
users to click the Add Record button in order to add a new
record; this feature is working fine after I put
Me.AllowAdditions = True in as an event procedure. Is
there a similar line of code that I need to put in the
DupRecord procedure?

Thanks!
Pat
.
Never mind! I just added Allow Addition = True to the
Click to expand...
DupRecord procedure, and it worked!
 
Back
Top