Forum Discussion
Form button has to be recreated every time Access closes and is reopened
I have a frustrating problem with a data entry form I created in my Access database. I created a button on the form (using one of the Form Design controls) that duplicates the current record every ti...
are you limited to macro only.
you can do it using VBA:
private button1_Click()
Me![anyTextboxOnYourForm].SetFocus
DoCmd.RunCommand acCmdSelectRecord
DoCmd.RunCommand acCmdCopy
DoCmd.RunCommand acCmdPasteAppend
end sub
you can do it using VBA:
private button1_Click()
Me![anyTextboxOnYourForm].SetFocus
DoCmd.RunCommand acCmdSelectRecord
DoCmd.RunCommand acCmdCopy
DoCmd.RunCommand acCmdPasteAppend
end sub