default print range

[RayB]

Hi. We've setup a large database in Access 2003.
On the print option, we manually change the radial button to "selected
records" each time. If someone forgets, we print under "all" a very large
file. How do we change the print default in Access only to "selected records"?
Thank You,
RayB.

 

[Evi]

Are you talking about the Radial button in Print when you go to print a
Query or Table? That is not the correct way to print records. Records should
be printed in a report.

The correct way to do this is to have the report open from a form which
filters it so that it only shows the required data.

For instance, you can create a combo box which is based on a Unique Query
showing all the dates in your form but only once each. Then your user
chooses a date and opens the report to show only the records for that date.

Or, if you just want to choose random, unrelated records to print, you would
add a Yes/No field your table so that the user can tick the records he
requires in your form. The query on which the report is based, is filtered
so that it only shows the records where this YesNo field is TRUE. The user
presses a button on the form and the code in the button will open the
filtered report and immediately after that set all the checkboxes to False,
ready for the next user.

Evi