Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SendObject Message body to include combobox value

Status
Not open for further replies.

nastar1

Technical User
Nov 1, 2005
122
US
I'm trying to use the SendObject to include a message that displays key elements of a specific record (the current record) from a current form.
In the example below the element 'TechID' is a combobox field from a table called Technicians.

strTicket = "Ticket#: " & Yr & "-" & Format([SeqID], "00000") & " Date Opened: " & _
txtDateOpened & " Tech: " & TechID

At present it displays the Technicians ID# and what I would prefer to do is have it display the Technicians last name instead. The table source 'Technicians' has a field called 'LastName' and this is what I would prefer to display within the message body of the email.

Any ideas on how I could do this?
 
Disregard.

It looks like all I needed to do was learn about using the .column() property to display the fields of my choice.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top