DLookup Formatting Question

[Huey462]

I would like to have Access take the data directly from a table rather than load it into a global variable when the generate email button is pressed.

My question is how do I format the Dlookup to snag this data?

Table: tblLetterData
Field: RepLetterBody
ID: = 1

 

[Joe4]

Where exactly are you trying to do this?
On a Form (I am guessing, since you mention a button)?
And then and you trying to return this to a TextBox on your Form?

 

[Joe4]

Let's say that the Command Button is named "Command10" and is populating a Text Box named "txtLetter". Then the code would look something like this:

Private Sub Command10_Click()
    Me.txtLetter = DLookup("[RepLetterBody]", "tblLetterData", "ID = 1")
End Sub

 

[welshgasman]

Something alonng the lines of

objMail.Body = DLookup("RepLetterBody", "tblLetterData", "ID = 1")

 

[Huey462]

Thank you so much, it was the quotes around the ID that was giving me issues. I really do appreciate it.