T. McConnell
Registered User.
- Local time
- Yesterday, 22:16
- Joined
- Jun 21, 2019
- Messages
- 63
Hey all,
If this is posted somewhere already then my apologies, if you could point me to that thread then that'd be great as well. If not then if anyone could give some suggestions I'd appreciate it.
What I am wanting to do is I have an order form for doing a work order. I finally got everything to work, and has a submit order button (which currently using a macro to submit and refresh/reopen the order form) I can also switch to VB if better/easier. What has been asked is on the submit form button it looks to see if "Invoice requested" checkbox has been checked, if so it will automatically print an invoice (report called simply Invoice) with the current records information formatted/filteted by query using the JobID PK. At the same time though on submitting the form it also will print the current record displayed.
Current setup for the form and report will use the current records JobID field to print off everything. Basically in addition to submitting the form be able to print both a report and the form of current record.
I could even create just one button to print invoice, (If the customer decides they want a copy) then have the main submit form button be the one that prints the current record off. Any ideas or suggestions I truly would appreciate it.
Thank you in advance!
If this is posted somewhere already then my apologies, if you could point me to that thread then that'd be great as well. If not then if anyone could give some suggestions I'd appreciate it.
What I am wanting to do is I have an order form for doing a work order. I finally got everything to work, and has a submit order button (which currently using a macro to submit and refresh/reopen the order form) I can also switch to VB if better/easier. What has been asked is on the submit form button it looks to see if "Invoice requested" checkbox has been checked, if so it will automatically print an invoice (report called simply Invoice) with the current records information formatted/filteted by query using the JobID PK. At the same time though on submitting the form it also will print the current record displayed.
Current setup for the form and report will use the current records JobID field to print off everything. Basically in addition to submitting the form be able to print both a report and the form of current record.
I could even create just one button to print invoice, (If the customer decides they want a copy) then have the main submit form button be the one that prints the current record off. Any ideas or suggestions I truly would appreciate it.
Thank you in advance!