Report based on table?

[SusanC]

Hi,
I have a report 'Cards' based on a table 'Pimbook'. I'm trying to find a way to set criteria so that I can have specific pages printed without having to sort through them manually, there is over 900 pages.

I would like a form that allows the user to put in a start number and an end number and then have a command button that brings up the report pages.

I've found information on parameter queries, expressions but they say to put it in the query. I don't really want to have to make my report again as it is quite detailed and I don't know if copying and pasting the report will work properly with all the correct fields.

Is this possible to do without have to redo the report based on a query?
thank you
Sue

 

[Rich]

How will they know which pages they want to print?

 

[SusanC]

How will they know which pages they want to print?

They'll be getting the numbers they need from another source, so then they can just put them in the form and have the reports return the pages to be emailed.
Is that what you meant?

 

[Rich]

Without knowing the specifics of your db design I'd have said that it's much easier to limit the records feeding to the report than to try and print specific pages

 

[SusanC]

Without knowing the specifics of your db design I'd have said that it's much easier to limit the records feeding to the report than to try and print specific pages

yes that's what I want. I can sort out the printing afterwards. I just need a way of putting in the criteria without putting in a new report and query. Any ideas?

 

[o1110010]

I know there is a macro command named PrintOut or something like that. (If you can't find it, I will be on a computer with Access on it later today to double-check. ) You can set the print range via that command.