SO CLOSE...PLEASE HELP! Access Keeps Asking For Parameters For Every Sub-Report!

[italianfinancier]

Good morning everyone...I am just about done with a large project for someone of my limited skillset with Access. The last thing I have to figure out is how to stop Access from prompting a user for a customer number for each subreport (i.e. parameter). It also asks me to enter my textbox "Text4" into the parameter, which should be coming from the Form.

I have it set up that the user enters a customer number on a form and clicks a button. When that button is clicked, it begins to generate the report, but prompts the user for the customer number for each and every subreport on my report.

How do I get it so that these parameters are automatically supplied/assumed to/by Access based on the customer number the user entered into the form?

 

[Trevor G]

You seem to be asking the same question when a solution was previously suggested. See your other thread

http://www.access-programmers.co.uk/forums/showthread.php?t=210639

If you don't want to follow the suggested solution then make each sub report source to look at the form textbox.

The reason why you will have something saying textbox4 is because you haven't referred to it correctly or named it properly or selected the wrong thing to use.