Changing form propeties in an OnLoad Event?

[FiendClub]

I have a subform based on a query. The orders form opens with a customer up and the user can see all orders placed by the given customer in this sub form.

Problem: sometimes this form appears blank and I've noticed to get the form to appear correctly I have to reset the following (subform)form properties to True. AllowEdits/AllowAdditions/ AllowDeletions/ DataEntry.

1.) Why would this form suddenly change its properties to = fase/no. (problem occurs mostly using Access97 on a Win95 system)

2.) The fix I tried is below, but being new to VBA I'm not confident it is even executable. Does the VB look good for OnLoad? If not, any other suggestions?

Private Sub Form_Open(Cancel As Integer)
    AllowEdits = False
    AllowDeletions = False
    AllowAdditions = True
    DataEntry = True
End Sub

 

[momon]

I'm no expert. But if you above code doesn't work you could try this:

Private Sub Form_Open(Cancel As Integer)
Me.AllowEdits = False
Me.AllowDeletions = False
Me.AllowAdditions = True
Me.DataEntry = True
End Sub


Hope this helps!

 

[FiendClub]

Thanks for the Me suggestion I threw that in to be safe. Still have yet to have the problem re surface. We'll see? Any other suggestions are welcomed.