How to filter reports based on user input? 1

[merv805]

I am creating a purchase order system. I have created a welcome screen that has a command button that should be able to print out the purchase order report. The question is how do I restrict that report to only display the report based on the purchase order # the user wants? Is there a way to create a msg box or parameter screen so that when the user presses the commmand button the user just types in the purchase order # and the report will only display the according information?

Thanks

 

[GingerR]

there are a few ways, one of which is this:

in the query that your report is based on, in the CRITERIA for the Purchase Order Number, put

 [Enter PO Number:]

Access then prompts the user for that information
you can put whatever you want between the brackets, that is just what the user will see.

hope this helps.

g