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]