Hi all,
I'm having kind of a weird problem and I'm not able resolve it. Here's what's happening:
I have a main for that has a button on it to open a pop up form. However, sometimes when I ope the form it doesn't open. I can open it three or four times sometimes without a problem then out of the blue it doesn't open. When I go into design view it looks like the form has been reduced down to it's smallest size and it order to view it I have to maximize it. After maximizing it I can save and open the form again and it opens properly. However, after opening it a couple of times the same thing happens.
Here's what I've tried so far:
1 - On Form open and load I tried this:
Private Sub Form_Open(Cancel As Integer)
DoCmd.Restore
DoCmd.RunCommand acCmdSizeToFitForm
End Sub
2 - Set Auto Resize to "No"
3 - Recreated the form from scratch and it still happens.
4 - Did compact and repair on DB
PS. the pop up form has sub form on it. Would that cause any issues?
I'm having kind of a weird problem and I'm not able resolve it. Here's what's happening:
I have a main for that has a button on it to open a pop up form. However, sometimes when I ope the form it doesn't open. I can open it three or four times sometimes without a problem then out of the blue it doesn't open. When I go into design view it looks like the form has been reduced down to it's smallest size and it order to view it I have to maximize it. After maximizing it I can save and open the form again and it opens properly. However, after opening it a couple of times the same thing happens.
Here's what I've tried so far:
1 - On Form open and load I tried this:
Private Sub Form_Open(Cancel As Integer)
DoCmd.Restore
DoCmd.RunCommand acCmdSizeToFitForm
End Sub
2 - Set Auto Resize to "No"
3 - Recreated the form from scratch and it still happens.
4 - Did compact and repair on DB
PS. the pop up form has sub form on it. Would that cause any issues?