Checkbox default value problem

[shod90]

Dear All,


Am trying to set a checkbox when it should be ticked some text boxes will be dimmed. It's working perfect but there is a problem when opening the form for the first time - by default it's checked, I have to double click on it to remove the check to let me enter the data in the dimmed areas.
It should be like that

But actually when the form starts it's like that

here is my code

Private Sub Holiday_Click()    
If Me.Holiday = True Then
    Me.WorkItems.Enabled = False
    Me.SubProject.Enabled = False
    Me.Hours.Enabled = False
    Me.ProjectID.Enabled = False
Else
    Me.WorkItems.Enabled = True
    Me.SubProject.Enabled = True
    Me.Hours.Enabled = True
    Me.ProjectID.Enabled = True
End If
End Sub

[June7]

Checkbox is bound to field? Does field have DefaultValue property set?

[shod90]

Checkbox is bound to field? Does field have DefaultValue property set?

Yes it's bounded to field , But don't have default value

[Rivanni]

At the form load event set the enabled status of the text boxes based on the Holiday value.

[Missinglinq]

Sorry, but this doesn't really make sense! First you say

"...by default it's checked..."

Then you say

"...But don't (sic) have default value..."

So, does it have a Default Value or not? If it doesn't have a Default Value...how do you expect it to have a Default Value?

And, as Ravinni suggested, what happens when the Checkbox is ticked has nothing to do with what occurs when the Form opens! If the Form opens to a New Record, set the formatting as you want it, which, if I read it correctly, is having WorkItems, SubProject and Hours all disabled.

Linq ;0)>