Form load event procedure doesn't work

[Guest]

I'm having a problem with an Access form named 'Form1' using VBA. I'm trying
to set an event procedure when the form opens to initialize form attributes
(e.g., enabling a check box named 'CheckAll'). The problem is that Access
attempts to set the attributes before the form even opens - thus, the
attributes don't set. Here's the code:

Private Sub Form_Open()
Me.CheckAll.Enabled = True
End Sub

I've tried using: me.checkall..., form1.checkall..., checkall..., etc. I've
also tried different events like: Form_Load(), Form_Initialize(), -- and
also, Form1_Load(), Form1_Initialize(), etc. Having no success. Anybody
have a solution??

 

[Guest]

Put the code on the on current event of the form.

 

[fredg]

I'm having a problem with an Access form named 'Form1' using VBA. I'm trying
to set an event procedure when the form opens to initialize form attributes
(e.g., enabling a check box named 'CheckAll'). The problem is that Access
attempts to set the attributes before the form even opens - thus, the
attributes don't set. Here's the code:

Private Sub Form_Open()
Me.CheckAll.Enabled = True
End Sub

I've tried using: me.checkall..., form1.checkall..., checkall..., etc. I've
also tried different events like: Form_Load(), Form_Initialize(), -- and
also, Form1_Load(), Form1_Initialize(), etc. Having no success. Anybody
have a solution??

The Form's Open event is to early in the loading process.
Use the Form's Load event instead.

Private Sub Form_Load()
Me!CheckAll.Enabled = True
End Sub