Validation Rule?

• itags.org

  Newbie

  Points: 1

  More actions

  July 20, 2009 at 3:14 am

  #71739

  I have a form to enter data.

  There is a number field and a Date field I want to make sure the user enters something into. If not, and they try to close the form, I want an error box to pop up and tell them they cannot leave it blank.

  Any ideas how to accomplish this?

• Chris Quinn-821458

  Hall of Fame

  Points: 3192

  More actions

  July 21, 2009 at 5:08 am

  #1027519

  In the BeforeUpdate event, you check the fields and issue a cancel i it fails your validation

  e.g.

  Private Sub Form_BeforeUpdate(Cancel As Integer)

  IF NZ(Me.txtDate,"") = "" then

  Msgbox "You must enter a date", vbCritical + vbokonly,"Validation Error"

  me.txtDate.Setfocus

  Cancel = True

  End If

  End Sub