I have one control txtCancellationDate(locked property is true) on a subform that won't null on status change (combo box)
I have
Code:
If StatusID = 5 Then
Me.txtCancellationDate.Value = Date
Me.Box408.Visible = True
Me.CancellationContact.Visible = True
Me.txtCancellationDate.Visible = True
Me.CancellationNotification.Visible = True
Me.CancellationReasonID.Visible = True
Me.BookingsID_tblBookings.Visible = True
Me.Label403.Visible = True
Me.Label404.Visible = True
Me.Label405.Visible = True
Me.Label406.Visible = True
Me.Label407.Visible = True
Else
Me.txtCancellationDate.Value = Null
Me.CancellationContact.Value = Null
Me.CancellationReasonID.Value = Null
Me.Box408.Visible = False
Me.CancellationContact.Visible = False
Me.txtCancellationDate.Visible = False
Me.CancellationNotification.Visible = False
Me.CancellationReasonID.Visible = False
Me.BookingsID_tblBookings.Visible = False
Me.Label403.Visible = False
Me.Label404.Visible = False
Me.Label405.Visible = False
Me.Label406.Visible = False
Me.Label407.Visible = False
End If
The string and integer fields null fine - just not the date field (not sure if because it is locked by why should that matter??