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?
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?