Create a report when a form is completed by the user. Purchase Order Database

[dwalsh]

When a purchase order form is completed by the user, I would like a Purchase Order Report to be created by the click of a button. I currently have a parameter query which asks the user to enter the purchase order number to open a report based off a form that they just completed. This becomes annoying for the user as they should not need to re enter the purchase order number to create a report to print. Any help greatly appreciated.

[Dave14867]

I believe this can be done using a command control and use the "Loaded Form" ID in a query to create the report. If you can zip and attach a stripped down version of the database I will take a look and see what can be done.

[dwalsh]

Thanks Dave. I have attached the file. There is only 1 record in each table for testing purposes.

[Dave14867]

Try this and see if this is what you want. There are issues with the design that should be addressed like spaces in table names etc. Correcting these now will save many issues down the road.

Let me know if this is what you were trying to achieve and we can discuss other things if you want.

PO- Dummy Data-Dave1.zip

[dwalsh]

Thanks Dave for your help. That is exactly what I wanted to achieve. Many thanks

[Dave14867]

Glad I could help, if you take a look at the query you will see that I changed the "Enter PO Number" to use the Open PO ID

[dwalsh]

Hi Dave. I am using a dropdown menu in the main subform to select a customer. The list could get extremely long but I could not think of a better way. At least when the user picks a customer the rest of the row is automatically filled in. Is there any other way to avoid using the combo box? Just for my own learning, I could not find the exact location in the query where you fixed the issue I had. Thanks for the help.

[Dave14867]

I would continue to use the combo box myself but you don't have to use it as a dropdown, you can start typing in the field and it will begin to autofill, when the user moves off the field, it will accept the entry if the autofill was successful, I use this method on most fields in 1 database and it works fantastic. I enter lot numbers linked to other tables, if the lot number isn't already in the corresponding table it will not allow the entry thus forcing the other entry to be made prior to allowing finalizing the current entry.

Look at the command button for printing the PO, specifically the event tab, onclick event, look at the query associated with that event.

[dwalsh]

Thanks Dave