Sending a form from access via outlook to a specific user

[jfiguereo6]

Hello Everyone,



I have built a Travel database and what I'm trying to accomplish is sending the form. For instance, If I fill out the form with the travel information, expenses, destination, etc. at the bottom I specify a manager who needs to approve my request. I have two command buttons one to save the record and the other to submit. What I would like to happen is that when the person filling out the form clicks the submit button an email generates to the manager they've selected with a link of that specific form in the message body. Then when the manager receives the link they go in open the form approve it and then when the manager clicks the submit button I would like it to send the form to our financial personnel. Not sure how to work this code in, any help would be greatly appreciated. Thanks.

[ranman256]

DoCmd.SendObject acSendForm, "frmMain", acFormatPDF, vTo, , , vSubj, vBody

[June7]

Review https://www.accessforums.net/forms/e...orm-54233.html

[jfiguereo6]

Thanks for the update, is there any way to send a link to the form instead of a PDF file? In order for managers to open directly to the edited form?

[June7]

That would be opening the db. The db can be set to open that form by default but it won't be filtered to the record.