How do I set it up so that Access only asks for one criteria

italianfinancier

Registered User.
Local time
Yesterday, 20:14
Joined
May 26, 2011
Messages
33
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?
progress.gif
 
Put the value into a textbox on a form and refer to that textbox from the query.

Forms!formname.textboxname
 
I just have a Form and a Report...no Query. Please see attachments and let me know where I am going wrong. :confused:
 

Attachments

  • Untitled.jpg
    Untitled.jpg
    92.1 KB · Views: 99
  • Untitled1.png
    Untitled1.png
    47.4 KB · Views: 88

Users who are viewing this thread

Back
Top Bottom