I have a database that is used once a year. It worked last spring but is showing errors now. I am using Vista and Office Professional 2003.
The expression On Click you entered as the event property setting produced the following error: object or class does not support the set of events. Private Sub
Here is a sample of the code that is causing the error:
rptSettlement_Click()
On Error GoTo Err_rptSettlement_Click
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "frmPrtSettlement"
DoCmd.OpenForm stDocName, , , stLinkCriteria
Exit_rptSettlement_Click:
Exit Sub
Err_rptSettlement_Click:
MsgBox Err.Description
Resume Exit_rptSettlement_Click
The (mdb) does not work but the (mde) created last year works fine. How do I solve the problem so that my (mdb) file works?