How to print selected records of a Report

[Fyeung]

Hi everyone,



Do you have any idea on how to print selected records of a Report? I have created a Access database and a Report of 3,000+ records for all of our countries' subsidiaries, but I just want to select and print out the records of specific countries (say, UK).

Please advise, thanks.

Best Regards
Fred

[June7]

Apply filter to the report. Options:

1. manually setting static filter in report's RecordSource

2. dynamic parameterized query - either with popup prompts or reference to control on form
http://www.datapigtechnologies.com/f...mtoreport.html

3. pass filter criteria to report when it opens - with macro or VBA
again, reference controls on form
DoCmd.OpenReport "report name", , , "Country='" & Me.tbxCountry & "'"
Review: http://allenbrowne.com/ser-50.html

[NTC]

just to add on to J7 advice: fundamentally you need a report with just the records wanted to print. Your post discusses a report with 3000 records and a desire to print a subset - - but that is putting the cart before the horse. You need to think in terms of first creating a report that has just the records wanted to print - even if it exists only for the purpose of printing.

A filter per J7 instruction - or - copy your report and create for it a new records source which is a query and make that query design to have just the records you want printed.

[Fyeung]

Many thanks for your help

Rgds,
Fred

Apply filter to the report. Options:

1. manually setting static filter in report's RecordSource

2. dynamic parameterized query - either with popup prompts or reference to control on form
http://www.datapigtechnologies.com/f...mtoreport.html

3. pass filter criteria to report when it opens - with macro or VBA
again, reference controls on form
DoCmd.OpenReport "report name", , , "Country='" & Me.tbxCountry & "'"
Review: http://allenbrowne.com/ser-50.html