Sincere apologies that this question is posted twice - it occurs that this may be a better forum for it than the VBA module forum.
I'm creating a database for our company that is letting us put together orders quickly (we order items from about 75 different companies, so moving them all to a centralized system is going to speed things up drastically), and have created the necessary forms and tables to put the orders together easily. I've also created a report to serve as a P.O., and created a button that creates the PO and sends it to the people who do the actual ordering.
The problem is that orders over a certain amount of money need approval prior to going in to be ordered. In fact, depending on the amount of money and the department of the employee doing the ordering, there are five different people that the e-mail would maybe have to go to.
All the values for this (Employee ID, Order total) are on both the form with the e-mail button and on the report - is there a way to automatically e-mail the report to the correct person based on the Employee ordering and the total amount as listed in the form or the report?
I'm creating a database for our company that is letting us put together orders quickly (we order items from about 75 different companies, so moving them all to a centralized system is going to speed things up drastically), and have created the necessary forms and tables to put the orders together easily. I've also created a report to serve as a P.O., and created a button that creates the PO and sends it to the people who do the actual ordering.
The problem is that orders over a certain amount of money need approval prior to going in to be ordered. In fact, depending on the amount of money and the department of the employee doing the ordering, there are five different people that the e-mail would maybe have to go to.
All the values for this (Employee ID, Order total) are on both the form with the e-mail button and on the report - is there a way to automatically e-mail the report to the correct person based on the Employee ordering and the total amount as listed in the form or the report?
