Dlookup with criteria of textbox

[thescottsman92]

Hi All

I have a form that I need to get the email address of into a textbox.

So far I have a textbox that the user choose the full name of the person from a combo box

I have another textbox that sould display the email address. I ca get it to display the email address of the first name in the table b8ut it does not change when I enter a different name. I have entered this code:

Private Sub sendchoose_AfterUpdate()
Dim stremail As String
stremail = DLookup("EmailAddress", "Operators", "FullName")


Me.ccsendto = stremail
End Sub

in the after update event on the combo textbox

thanks for your help

[amrut]

Correct your syntax for Dlookup
See http://www.techonthenet.com/access/f...in/dlookup.php

[thescottsman92]

Thanks for the reply

I have looked at that age before yes it helps in forming the structure but does not help me problem

basically I want a statement that is like

=dlookup("EmailAddress","Operators","Fullname=me.s endchoose") but as fair as I know (and I have little experience) you cant but the statement like that. Any other way to form this?

Thanks

[amrut]

Look at it again, particularly note the use of delimeters ' and #.
If your fullname is a text field, then

dlookup("EmailAddress","Operators","[Fullname]='" & me.sendchoose & "'")

Note the single quote ' in red color.