Activating Controls according to fields

[chemram]

How can I get controls on a form to become active or inactive depending on the value of another form field?

eg. if a field called "exit date" is null it will make the control "exit reason" inactive until a date is put in..??

 

[Talismanic]

chemram, you can do it with this:

Private Sub ExitDate_Exit(Cancel As Integer)

If IsNull(Me.ExitDate) Then
ExitReason.Enabled = False
Else
ExitReason.Enabled = True
End If

End Sub