So I have a combo box for techs and a mail function built to pre-populate information in an email. What happens is it pulls the tech (or Assigned To) record ID value, not the name, i.e.
...closed by 7... instead of ....closed by FirstName LastName....
I have tried to use strHelpDesk = Me.[Assigned To].column2 to no avail.
Here is my code:
'-- Helpdesk employee ticket assigned to
strHelpDesk = Me.[Assigned To]
'--Email subject and details
stSubject = "Ticket: " & stTicketID & " has been closed"
stText = "Ticket number: " & stTicketID & " for " & stDetails & " was closed by " & strHelpDesk & " on: " & RecDate & Chr$(13) & Chr$(13) & "If this ticket was closed in error, please contact the Help Desk to re-open ticket." & Chr$(13) & "This is an automated message." & _ " Please do not respond to this e-mail."
My Combo Box for Assigned To:
SELECT Techs.ID, Techs.[FirstName] & " " & Techs.[LastName] AS Expr1 FROM Techs ORDER BY Techs.[FirstName];