Set unbound checkbox to false on open not working

[Garindan]

Hi all, simple question... I have a report with an unbound checkbox which has a null (greyed out value) when printed. I'm just trying to set it to false when the report opens.

I have

Private Sub Report_Open(Cancel As Integer)
Me.CheckNotPaid = False
End Sub

but it just says 'Runtime Error -214....... You can't assign a value to this object'

 

[pr2-eugin]

Try Form Load instead.

 

[Garindan]

Brilliant! Thankyou!

 

[pr2-eugin]

The reason why Open did not work when Load worked was because of the Order of Events. When a Form/Report is Opened, it knows nothing about the controls. It opens the Form Object and then instantiates all controls. So technically an Open method is too early to modify control values, as they might not have been set yet. However Load is triggered after the Form is loaded with the controls. Which is the right time to make changes.

Hope that helps ! Good Luck !