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