Make form field mandatory based on other field value

[Jon von der Heyden]

Hi
How do I configure a form field to be mandatory depending on the value of the previous field.

If [Usage] = "Install" then make [Job_Number] mandatory?

I'm sure I can code an event based on the change of [Usage] but I suspect there may be an alternative.

Thank you.

 

[SydneyGeek]

Hi Jon, you validate those sorts of business rules at the record level.

So, in the form's BeforeUpdate event you put code like...

If [Usage] = "Install" Then
  If IsNull([Job_Number]) Then
    MsgBox "You must enter a job number for an installation"
    [Job_Number].SetFocus
    Cancel = True
  End If
End If

Denis

 

[Jon von der Heyden]

Hi Denis

Code it is Thanks for this...