View Full Version : Activating Controls according to fields


chemram
01-12-2001, 04:57 PM
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
01-12-2001, 06:32 PM
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