Making one field required based on the value of another field

[emzadi]

How do I make one field required if another field is filled in, but not required if that other field is left blank?

Thanks! Susan M. Wagner
LAPELS
susanw@lapels.com

 

[JerryDennison]

Add code in the On Current event procedure for the form to test the value of the control in question. If it's not null then display a message, cancel the event, and take the user to the control that must be filled in.

Private Sub Form_Current()
If Not IsNull(Me.Control1) Then
If IsNull(Me.Control2) Then
MsgBox "You must enter a value for Lot #", vbInformation
DoCmd.CancelEvent
DoCmd.GoToControl "Control2"
Exit Sub
End If
End If
End Sub

 

[MichaelRed]

I would place any "validation Code" in an event triggered by the EXIT from the form (e.g. BEFOREUPDATE). This allows the user to do what they want without annoying 'Stuffffff'. If they are familiar with the requirements, they will fill in the correct (e.g. necessary) fields. If they FAIL to do it properly, you can alert them to any/all probelms (and usually suggest crrections?) at one time.


MichaelRed
mred@duvallgroup.com
There is never time to do it right but there is always time to do it over