VBA in Ms Access - ENTER THIS THREAD TO WIN MY ADMIRATION

[jcavard]

Hi!

I am trying to design a small Access interface that would send an email to the address selected in a drop down list. I have this, but I get an error saying it ain't activated ...

the attached screenshot is french, sorry, but it says something like: "cannot refer to or define a property if the object is not active" Error 2185...

Private Sub Commande0_Click()
    
    DoCmd.SendObject , , , email.Text, "kjhkhj", "kljhkhj", False
 
End Sub

[jcavard]

ok ok , finnally found it on another forums.

    DoCmd.SendObject , , , Me!email.Column(1), , "kjhkhj", "kljhkhj", False