Access Database closes when attempting to open up a form

[mp3909]

Hi All,

I am looking at this Access Database that was working fine up until last Monday and now it has stopped working.
When I click one of the buttons after few seconds my access database just closes.
The button I am clicking has the following VBA code behind it:

Private Sub cmdMenu2_Click()

On Error GoTo errorhandler
    DoCmd.OpenForm "frmLimits"      'it gets here and then it goes to the next block of code below
    
Exit Sub

errorhandler:
    MsgBox Err.Number & " : " & Err.Description
End Sub

Private Sub Form_Open(Cancel As Integer)

Static MouseHook As Object
     Set MouseHook = NewMouseHook(Me)     'from here it goes to the next block of code which I have attached as a snaphot because the code is too big to paste on here.

End Sub

In that attached snapshot, where the yellow cursor is is where the application closes.



Does anyone know what the cause and fix is please?

Thank You

[Bob Fitz]

There have been many posts of unexpected faults in many of the Access forums. Most of these faults seem to be the result of an update that ms issued recently.
Reverting back to before the update or making sure that the files are in a trusted location seems to be the only fixes, I believe.

[Micron]

I haven't used that function for a long time and it was to allow mouse wheel scrolling on a datasheet (or was it a continuous) form. Hasn't that been fixed long ago, or do you need it for some other reason?