How to make a field required based on another selection. 1

[rkb0378]

I am planning on using the "before update" event to validate a field.

Can someone help fill in the english with some code!!!

The form is used to enter different types of work.

If WorkType.value = "Payroll" then
[PAYROLL END DATE] is required.
else
do nothing
End If

Thanks

Rob

 

[Lightning]

Something like this should do what you need.

If  WorkType.value = "Payroll" then
    [COLOR=Blue]If IsNull([PAYROLL END DATE]) then
        MsgBox "You must enter an End Date", VBOKOnly, "Missing End Date"
        Cancel = True
        Me.[Payroll End Date].SetFocus
    End If[/color]
else 
do nothing
End If

HTH
Lightning

NB: Code TYPED, not CHECKED

 

[rkb0378]

Worked perfect thanks.