Duplicate a record in a tabular subform

[naterook]

Hey everyone. I can't figure out why this works only sometimes. I have a Tabular (continuous) subform. I've added a Duplicate Record button to duplicate my subform records. However, I click on it once or twice and it works. Then I click again and it gives me the error 'The command or action 'Paste' isn't available now'.

I think I've even gotten as far as the 4th click before this error comes up...

Any ideas on why this sometimes works and sometimes doesn't?

 

[naterook]

I've gotten this far: https://stackoverflow.com/questions...-command-or-action-paste-is-not-available-now

Maybe I need to slow it down before the paste option.
But the duplicate record button creates a macro, not a VBA sequence. I've tried writing the dba sequence and it doesn't like the word 'pause' as a command.

Still working on this...

 

[pbaldy]

It doesn't like "pause" because it isn't a valid command. You can try DoEvents.

 

[arnelgp]

you can also use this alternative:

With DoCmd
    .RunCommand acCmdSelectRecord
    .RunCommand acCmdCopy
    .RunCommand acCmdPasteAppend
    .GoToRecord , , acLast
End With

 

[naterook]

you can also use this alternative:

With DoCmd
    .RunCommand acCmdSelectRecord
    .RunCommand acCmdCopy
    .RunCommand acCmdPasteAppend
    .GoToRecord , , acLast
End With

Perfection!
Is it the PasteAppend that's fixing it? In other words, if it's just 'paste', is it going to fast, but if it's paste append, it's not pasting it in the current field, but instead adding it to the bottom of the table?

Thank you for this!

 

[arnelgp]

s it going to fast, but if it's paste append, it's not pasting it in the current field, but instead adding it to the bottom of the table?

you need to test it to see for yourself.