By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,566 Members | 1,779 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,566 IT Pros & Developers. It's quick & easy.

How to include form data in subject of SendObject

P: 13
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.
Jul 8 '10 #1

✓ answered by AccessQuestion

SOLVED!!! I did a Subject = "Your Order " & Me.OrderID and it worked.

Share this Question
Share on Google+
1 Reply

P: 13
SOLVED!!! I did a Subject = "Your Order " & Me.OrderID and it worked.
Jul 8 '10 #2

Post your reply

Sign in to post your reply or Sign up for a free account.