How do I get Access to only ask me for criteria once?

[italianfinancier]

I made a report that pulls data from many tables and, for each list in my report, Access asks me for criteria in a box. How do I set it up so that it only asks for one criteria (since all are the same - customer number) and assumes it is the same for all the other criteria?

[pbaldy]

You have the user input the criteria on a form, and have all your queries pull the value from there. You can use the Build function in the criteria or type it in:

http://access.mvps.org/access/forms/frm0031.htm