compile error in hidden module

[pungentSapling]

I am getting athe following error message when I try to make an mde database

compile error in hidden module Form_frmReferance

does anyone know how to access the hidden module in order to look for the problem?

 

[Fuga]

Have you tried repairing the db?

Fuga.

 

[pungentSapling]

yes, to no avail
I have made mde copies of this db before... today I was editing the main form, went to save as mde and got the error.
I guess I am going to have to start over on the changes..

 

[Opengrave]

Have you shown all modules?
TOOLS->OPTIONS->VIEW then check HIDDEN OBJECTS

 

[pungentSapling]

i found out how to see the module.....It is just the code behind my form...I did not realize that it would be referred to as a hidden module.

Next question is why does it give me a compile error while making an mde. The database works fine as mdb. If there is a problem with the code why would i not get an error right away?

anyway here is the sub I changed does anyone see a prob?
[vbcode]

Private Sub cmdFin_Click()
On Error GoTo Err_cmdFin_Click
Me.Refresh
If Me.chkEHS = True Then
DoCmd.SendObject acSendReport, "rptService", acFormatRTF, "emailaddress@whatever.com, emailaddress@whatever.com", "emailAddress@whatever.com", , "Service Request", , False
Else
DoCmd.SendObject acSendReport, "rptService", acFormatRTF, "email address@whatever.com", "emailaddress@whatever.com", , "Service Request", , False
End If
DoCmd.Close
DoCmd.Quit

Exit_cmdFin_Click:
Exit Sub

Err_cmdFin_Click:
MsgBox Err.Description
Resume Exit_cmdFin_Click

End Sub
[/vbcode]

 

[Opengrave]

Go into the code window for the module and compile it there, it should highlight the line that has the error.

While viewing the code select the DEBUG menu then one of the compile options, I usually use COMPILE AND SAVE.