I have an EmployeeDetail main form with an embedded RemunerationHistory sub-form. On the main form, I have a command button to undo the record if a mistake is made. This works OK. I used the command button wizard to write the code and the relevant line which does the business is :
DoCmd.DoMenuItem acFormBar, acEditMenu, acUndo, , acMenuVer70
However, if the user enters some data in the RemunerationHistory sub-form and then realises there's a mistake and tries to undo the entries using the same command button, Access generates an error "The command or action 'Undo' isn't available now".
What is needed in order to allow the user to undo errors in the sub-form, please? The sub-form has its 'Default View' property set to Continuous Forms.