Validation

[Del_Piero_3]

Hi Guys,

I need to set validation rule on a field. I have done the the below:

Private Sub Form_BeforeUpdate(Cancel As Integer)

If IsNull(Me.SlideType) Then
MsgBox "You have not entered SlideType!", vbExclamation + vbRetryCancel, "Incomplete Form!"
Cancel = True
Me.SlideType.SetFocus
End If

It works fine, but I cant get it ignore it if I press cancel. Sometimes this data is not available so it has to stay empty. When I press retry it should take me to that field to make changes and with the cancel click it should allow me continue with the last command/action before the msgbox was brought up. Can anyone please help, thanks.

 

[Rickster57]

circles

If they press Cancel use the Exit Sub statement to exit out of your loop and set the focus to a different control.