I would like to disable and enable my menu bar upon certain conditions, how can I do that?
I had add, edit, save and cancel buttons for enabling and disabling entry of my text boxes.
Also I'm using 'DoCmd.GoToRecord , , acNewRec' in my add button,
'DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70' in my save button.
But for the cancel button, I dun seems to be able to use 'DoCmd.DoMenuItem acFormBar, acEditMenu, acUndo, , acMenuVer70', as it will undo any records and not the current record that I am at? How can I resolve this problem (undo current changes) or is there a better solution that maybe you people can advise me.