LookupRecord/SendEmail Access 2010 Web Macro

[gdgonzal]

Hello,

I am attempting to use a LookupRecord in conjuction with SendEmail to send an e-mail notificiation.
Basically when a records Status within a nested sub-form (ProductivityAmount) reflects "Request Mgr Approval" I want an e-mail to be sent to that mgr. The User (Assigned Buyer) is maintained in the same Users tbl along with their mgr's e-mail.

What's causing my issue is that initially I had the Status being maintained in the Main (Productivity) tbl but then I realized it really need to be maintained within the the sub-form(ProductivityAmount).

Now I realize I probably need to add this to sub-form(ProductivityAmount) After Insert and After Update but I cannot seem to wrap my mind around how to accomplish this from here.
I've included a screen shot of my current macro that isn't working and the screen shot of my main form to illustrate the parent-child subform where the approval status resides.
Thank you

 

[Beetle]

Are you still looking for a solution to this problem, or has it been resolved?

 

[gdgonzal]

Still looking...

 

[Beetle]

The description of your problem sounds similar to one that I helped another member solve in this thread. You may find some helpful information there. If not, post back and I'll try to provide more specific help for your issue.

 

[gdgonzal]

Thanks, I was able to resolve my issue.