Hi, I created a report that generates after a user enters a customer number in on a form and clicks "OK". When the user enters a customer number and clicks the button, Access displays a dialog box asking for parameters (i.e. customer number, etc.). I have the sub-reports on the report linking to queries and have set it up so that the queries have a criteria to only show data relating to the customer the user entered. How do I get Access to stop asking the user to enter the customer number so many times? I really want it to just take the user number entered on the form and automatically use that number as the parameter.
Any help would be GREATLY appreciated!