I have a form that a user can use to generate an invoice. The invoice number is automatically created and displayed on the form when the form is opened. When the user clicks the "Create/Print Invoice" button I want the invoice to automatically print. The problem I'm having is I don't know how to pass the invoice number that's on the form to the query the invoice "report" is based on. Now the user has to remember what the number is and print the invoice from another menu option.
note: In the query I have under the [Invoice Number] field [Please enter the invoice number you wish to print:]
Any and all help is appreciated.
Thanks
note: In the query I have under the [Invoice Number] field [Please enter the invoice number you wish to print:]
Any and all help is appreciated.
Thanks