Email From Form with Combo box

[tmulrooney]

I have a report when opened from my menu it calls the form "Selecthandler". The form has a combo box which references back to the table where all the handler info is stored. The Table is called "Registration" I have a command button which contains the code:

Dim stDocName As String
Dim strEmailAddress As String
Dim strSubject As String

strEmailAddress = [eaddress]
strSubject = "Confirmation Notification"
stDocName = "confirmationletter"
DoCmd.SendObject acReport, stDocName, , strEmailAddress, , , strSubject, "Miscellaneous Text"

When I select the handler from the list and hit the email command button error message says "Invlaid Use of Null value" I have narrowed my problem to the [eaddress] is not being found.

I have tried [registration]![eaddress] it did not work.
Can you help?

Thanks,
TIM

 

[bjackson]

if you are trying to refer to a combo box on a form that is open

forms![Selecthandler]![eaddress]