I have a MS Access to duplicate current record and it is generating an error when the user clicks [Duplicate] button and I have the following VB code:
DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
DoCmd.DoMenuItem acFormBar, acEditMenu, 2, , acMenuVer70
DoCmd.DoMenuItem acFormBar, acEditMenu, 5, , acMenuVer70
I am running Access 2013 on this computer. On other computers that are running ACCESS 2010, the [Duplicate] button works just fine.
I checked the settings in reference (please see the screenshot posted) between this computer w/ Access 2013 and working computer w/ Acces 2010 and it is the same.
Fyi, I use the following code to open the database and set recordset to the table.
Dim rst As Recordset
Dim db As Database
Set db = CurrentDb()
Set rst = db.OpenRecordset("customer
What do I need to do to make it work?