Automatically Enabled and Disabled Checkbox

[DDTiff]

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.

 

[MattGreer]

I'm not sure if this is exactly what you want, but:

Private Sub chkOverdue_Change()

If txtStatus = "Closed" then
    chkOverdue.checked=False 'This will uncheck the Overdue box, right?
    chkOverdue.Enabled = False
Else
    If Due Date < Today Date Then
    	chkOverdue.Enabled = True
        chkOverdue.checked=true
    End if
End if
End Sub

If you want to disable the check box, set the .Enabled property to FALSE. If you want to UNCHECK the box, set the .CHECKED property to FALSE. I don't know if you can uncheck a disabled checkbox, so test the order of the code. You might have to switch the order of the lines.

Thanks!!


Matt

 

[DDTiff]

Matt,

Thank you for response, but the code did not work because I want the checkbox to check and uncheck automatically when one of the condition is true or false. I wall try using Status_AfterUpdate & Status_BeforeUpdate (these two are not applicable to checkbox)event but that still did not work. Is there a work around way you could provide me. Thank you ahead of time for your help.

 

[MattGreer]

To set a checkbox true or false, just code it:


chkOverdue = True

or

chkOverdue = False

I'm sorry. I don't believe there's a .checked property for a checkbox.

Thanks!!


Matt