Pass parameter to A2000ReportToPDF

[Peter Bassett]

In my application I need to pass a parameter to Stephen Lebans' great
product so I can create individual PDFs for students based on their ID. The
report (more correctly, the underlying query) accepts the ID as a
parameter, so ideally I would run a query to get the list of students and
loop through that list, passing each student's ID to the subroutine which
runs the report. This code below which works when prompting for the ID does
not show an option to pass any parameters which I need to automate the
process:

DoCmd.OutputTo acOutputReport, RptName, "SnapshotFormat(*.snp)",
strPathandFileName

Any help is appreciated. I'm sure it's easy to get this to support
parameters.

 

[Stephen Lebans]

A quick search via GoogleGRoups will yield several relevant threads:
http://groups.google.ca/groups/sear...um=30&q=lebans+reportTopdf+filter&safe=images


--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.