enter select criteria from query to a report at printing?

  • Thread starter Thread starter Mr Edd
  • Start date Start date
M

Mr Edd

I have a query set up in access. And a report using that query. However,
when I want to use the report, I only need selected records from the query.
Would like to be able to do this without having to insert/change parameters
in the query each time. Could use either a drop-down menu listing options in
that field or direct entry of the selection I need.

Is this possible?
 
You can use a prompt [Enter you criteria] as criteria.

Or use an unbound form with unbound text boxes.
[Forms]![YourFormName]![TextBoxName]
 
Thanks for the reply. Have no clue what "prompt" is. Perhaps I can explain
better what I'm looking for.

File has 1300 records. Query has the details I need for the report.
However, I only want to print out the "report" using a select criteria of
only 2 fields from the file.

Namely VN and DN. Each report rquires only 3-5 items from the file. Right
now, I am entering VN and DN parameters each time I need to run each report.

What I'm wanting is to not have to enter these parameters in the query, run
report and then change parameters and run the next report.

Something where I can leave the specific parameters blank in the query and
when I get ready to print a report, have the option to either enter the VN &
DN before it prints only the report that matches these criteria OR a drop
down of the possible VN and DN options and I can select one from each.

Each report is used only once because it prints labels for my DVDs.

Example. VN=Volume # and DN=Disc number within that volume. So, if I wish
to print the label for something in VN 18 and Disc 5, then I want to just be
able to make these selections at some point in the PRINT cycle without having
to go into "design" to change parameters in the query.

Don't know if is possible. But, would be convenient if it is. Thanks to
anyone who can make suggestions or tell me it is not possible.
 
Karl's suggestion is that if you bracket your query criteria (that which you
don't like to have to change each time)....then when the query starts to run
it pauses and generates a prompt waiting for you to put that criteria in....
and you can put in what ever works....

seems like that would work in your case; if not - and if you are
comfortable with VB then explore the opening arguments for the DoCmd of open
report....
 
Back
Top