I have a text box called 'ClosedDate'
If the CheckBox 'Closed' is checked on the form, ClosedDate appears.
If Me.Closed = 0 Then
Me.ClosedDate.Visible = False
Else
Me.ClosedDate.Visible = True
End If
This works great except input is required in ClosedDate so even if it is not visible, input is still required (the field property 'Required' is set to YES in the table).
Is it possible to code that if ClosedDate is not visible, input is not required for ClosedDate?
If the CheckBox 'Closed' is checked on the form, ClosedDate appears.
If Me.Closed = 0 Then
Me.ClosedDate.Visible = False
Else
Me.ClosedDate.Visible = True
End If
This works great except input is required in ClosedDate so even if it is not visible, input is still required (the field property 'Required' is set to YES in the table).
Is it possible to code that if ClosedDate is not visible, input is not required for ClosedDate?