I have a form that the user fills out. When they hit the 'submit' button it not only saves the record, but it emails the info from the form in a report. The form/report has an 'Order ID' field. What I would like to do is in the subject line of the email have it say "Your order "+Order ID. I have tried a couple things under Subject like Your Order &Forms![My Form]![Order ID], but it didn't work. I know this is probably easy to do, maybe with VBA. Any help you can give me would be greatly appreciated. Thanks!
I tried to search the forums but the search function seems to not be working.
I tried to search the forums but the search function seems to not be working.
Comment