Hello,
Can someone please help me? I have a question about checkbox enabled and disabled capability. I would like to thank you in advance for your help.
I have a table call 'Items' with 'Status'; 'Due Date'; 'Overdue' and many other fields, but the condition only involves Status; Due Date; and Overdue. The Overdue field has a 'Yes/No' Datatype
I made a form using the 'Items' table and I would like the 'Overdue' checkbox to be disabled if the Status textbox value is equaled to "Closed" else enabled 'Overdue' checkbox if Due Date is less than Today's date.
Pseudocode
Private Sub chkOverdue_Change()
If txtStatus = "Closed" then
chkOverdue.checked=False
Else
If Due Date < Today Date then
chkOverdue.checked=true
End if
End if
End Sub
Once again, thank you for your help.
Can someone please help me? I have a question about checkbox enabled and disabled capability. I would like to thank you in advance for your help.
I have a table call 'Items' with 'Status'; 'Due Date'; 'Overdue' and many other fields, but the condition only involves Status; Due Date; and Overdue. The Overdue field has a 'Yes/No' Datatype
I made a form using the 'Items' table and I would like the 'Overdue' checkbox to be disabled if the Status textbox value is equaled to "Closed" else enabled 'Overdue' checkbox if Due Date is less than Today's date.
Pseudocode
Private Sub chkOverdue_Change()
If txtStatus = "Closed" then
chkOverdue.checked=False
Else
If Due Date < Today Date then
chkOverdue.checked=true
End if
End if
End Sub
Once again, thank you for your help.