Event if Null Field?

[hinser13]

I have a quote field, users currently click a cmd button to prompt a second pop up form, that adds one to the last quote no to create a new quote no.

How can I create an event to prompt this form if the field is null?

Thanks Mark

 

[John Big Booty]

You could test;

If IsNull(Me.YourFieldName) Then
     MsgBox "Please enter a Quote Number"
     Cancel = True
End If

 

[vbaInet]

If IsNull(Me![TheField]) Then
     msgbox "here's your prompt"
End If

 

[vbaInet]

I was very late there John.

 

[John Big Booty]

I was very late there John.

No problem, I'm just happy to have my solution validated