Unanswered: Join 2 fields from a table into the subject of email
So here is my code.
DoCmd.SendObject , , , "email@example.com", "firstname.lastname@example.org", , "A shipment has arrived for your job # " & [job name and number], "A shipment has been recieved for one of your jobs" & vbNewLine & "Items received are: " & [DESCRIPTION] & " " & "Notes added for this item: " & [NOTES], False, ""
I want the subject line in the email to read "A shipment has arrived for your job # (this would be a number from a table and the name from the same table)
I have a query named "packing slips query"
within that query i have a few fields one of which is "job number"
another is "job name and number" which is an expression that joins 2 fields from a linked table "Jobs". job name and number: [jid] & " " & [jobs]![description]
When i use [job number] the code works correctly
when i use [job name and number] i receive an error