Hi How can I undo a single field within a BeforeUpdate event for the field? Thanks Regards
J John Jun 17, 2008 #1 Hi How can I undo a single field within a BeforeUpdate event for the field? Thanks Regards
R Rui Jun 17, 2008 #2 check if field is 'dirty' (look for changes) and use the command DoCmd.DoMenuItem acFormBar, acEditMenu, acUndo, , acMenuVer70
check if field is 'dirty' (look for changes) and use the command DoCmd.DoMenuItem acFormBar, acEditMenu, acUndo, , acMenuVer70
A Al Campagna Jun 17, 2008 #3 John, Add two lines to whatever code you have... Cancel = True YourFieldName.Undo -- hth Al Campagna Microsoft Access MVP http://home.comcast.net/~cccsolutions/index.html "Find a job that you love... and you'll never work a day in your life."
John, Add two lines to whatever code you have... Cancel = True YourFieldName.Undo -- hth Al Campagna Microsoft Access MVP http://home.comcast.net/~cccsolutions/index.html "Find a job that you love... and you'll never work a day in your life."
