Need a Way to Interrupt IsNull MsgBox if User Eants to Start Over 1

[JSD]

Hello,

I am trying to add a restart button to a form in case user messes up. Button does an Me.undo and sets focus back to first control on form. The problem is when they hit the start over button when they are in a required field. My required fields have If IsNull, Then MsgBox functions and if I hit the start over when I'm in one of these fields, I get the required field Msg instead. Is there a workaround on this? Many thanks as always.

Jeremy

 

[cghoga]

Try creating an invisible text box on your form.
When the Start button is clicked set its value to 1.
In the same procedure that contains the If IsNull,
before the If IsNull have another If statement that exits the sub if the text box is = 1.

Like this:

If me.Nameofyourtextbox.value = 1 Then

Exit Sub

Else

'Your code would go here.

End If

 

[JSD]

cghoga,

This looks like a great idea. I'll get back to you when I have time to employ this. This bug is my highest priority.

Thanks very much

Jeremy