Submit Form Without Null Values (1 Viewer)

gtimmies · Jul 18, 2013

Hi,

I'm trying to build an expression where the form can only be saved if the field supervisor approval is not null.

Could you please let me know how I can do that?

Thank you!

missinglinq · Jul 18, 2013

How about this:

Code:

Private Sub Form_BeforeUpdate(Cancel As Integer) If Nz(Me.[supervisor approval],"") = "" Then MsgBox "The Supervisor Approval Field Must Not Be Left Blank!" Cancel = True [supervisor approval].SetFocus Exit Sub End If End Sub

replacing supervisor approval with the actual name of your Control.

Linq ;0)>

Submit Form Without Null Values (1 Viewer)

gtimmies

New member

missinglinq

AWF VIP

Similar threads

Users who are viewing this thread