Prev: test
Next: LINKING MASTER WITH SUB-SUBFORM
From: Bob Vance on 11 May 2010 05:03
I am wanting to enter tblOwnerInfo.LastName,"," TblOwnerInfo.FirstName with
the tblOwnerInfo.Email (Address) to Sent Items to box?
Is this Possible

strMail = Nz(DLookup("Email", "tblOwnerInfo", "OwnerID = " & lngID), "")


Public Function OwnerEmailAddress(idOwner As Long) As Variant

If IsOwnerWithEmail(idOwner) Then
OwnerEmailAddress = DLookup("[EMail]", "tblOwnerInfo", "[OwnerID]="
& idOwner)
Else
OwnerEmailAddress = Null
End If

End Function




--
Thanks in advance for any help with this......Bob
MS Access 2007 accdb
Windows XP Home Edition Ver 5.1 Service Pack 3


 | 
Pages: 1
Prev: test
Next: LINKING MASTER WITH SUB-SUBFORM