Toggling checkbox and text box enabled status

[MarcusM]

I have the following on a subformate of Order: [textbox]Order Cancelled: [checkbox]When I enter the date , from a date picker, I need the checkbox disabled and also I need the textbox disabled/enabled according to the checkbox value.So far the program is not consistent.Private Sub chckbxOrder_Cancelled_Click() 'Toggle txtDate_Of_Order.Enabled property according to the checkbox status. If (Forms!Order!OrderSubform.Form!chckbxOrder_Cancell ed.Enabled = True) Then txtDate_Of_Order.Enabled = False End If End SubPrivate Sub Form_Current() If (IsNull(Forms!Order!OrderSubform.Form!txtOrder_Num ber.Value) Or _ Forms!Order!OrderSubform.Form!txtOrder_Number.Valu e = "") Then Forms!Order!OrderSubform.Form!txtDate_Of_Order_Num ber.Enabled = True Forms!Order!OrderSubform.Form!chckbxOrder_Cancelle d.Enabled = True ElseIf (IsNull(Forms!Order!OrderSubform.Form!txtDate_Of_O rder.Value) Or _ Forms!Order!OrderSubform.Form!txtDate_Of_Order.Val ue = "") Then Forms!Order!OrderSubform.Form!txtDate_Of_Order.Ena bled = False Forms!Order!OrderSubform.Form!chckbxOrder_Cancelle d.Enabled = True Forms!Order!OrderSubform.Form!chckbxOrder_Cancelle d.Value = True ElseIf (Forms!Order!OrderSubform.Form!chckbxOrder_Cancell ed.Enabled = False) Then Forms!Order!OrderSubform.Form!txtDate_Of_Order.Ena bled = True Else Forms!Order!OrderSubform.Form!txtDate_Of_Order.Ena bled = True Forms!Order!OrderSubform.Form!chckbxOrder_Cancelle d.Enabled = False Forms!Order!OrderSubform.Form!chckbxOrder_Cancelle d.Value = False End IfEnd SubWhen it reaches a blank record it keeps the condition of the last record. E.g.: the last record has the checkbox cancelled and so the textbox is disabled. When I move to a blank record it shows the textbox is disabled even though the checkbox is not checked.I put a breakpoint on the Current event and it does not seem to be working when I click the 'Next' button and land on the last record specifically.Remember this is a form/subform situation and the checkbox and textbox are on the subform.

[pbaldy]

Maybe something happened when you pasted the code, but it's unreadable. On a new record, the checkbox could be Null, so perhaps you need to test for that.