Search results

Thanks Wayne... I put the following code in the AFTER update event and it works beautifully! Me.ClearanceHolder = Me.ClearanceHolder.OldValue Me.WorkRequirements.SetFocus Exit Sub End If Thank you all for your help!

Hi KeithG, Thanks for your reply. That is one option that I tried initially. It does cancel the update event but leaves the "new" value in the control. To remove it and restore the initial value, the user would hit the escape key. I am trying to "do the work for them" and prevent errors. Any...

confused:Does any one have a solution for the problem with a setfocus following an undo and cancel event raising the following error? Run-time error 2108: You must save the field before you execute the SetFocus method. I am trying to a "simple" data validation. Based on a choice in an option...