Error Number 2645

[janliv1102]

"Error Number: 2465 Microsoft Office Access can't find the field 'email'
referred to in your expression" I am getting this error message when I try to
run my event procedure. Below is the code that I am using. Please Help.
Thanks

DoCmd.RunCommand acCmdSaveRecord

EmailAddress = Me!email

With objMailItem



.To = EmailAddress

.Subject = "Unpaid Invoices"

.body = "You currently have unpaid invoices"

.display

End With



Exit Sub

ErrorHandler:

MsgBox "Error Number: " & Err.Number & " " & Err.Description





End Sub

Private Sub Form_DblClick(Cancel As Integer)

End Sub

 

[Danny Seager]

Sory to point out the obvious but....

Have you checked that there is a control on the form called email