output to multiple pdf files

[geoffishere]

Hi all

Is there a way of doing this. I have a report which contains a page for each member of staff.I currently can view individual pages using a form which filters the report.



I am using 2007 so i can easily output the whole report to Pdf, what i need to do is output each indivual staff report to a seperate Pdf file ideally named by a field in the report.

Is this possible, i guess i would have to use vba

Many Thanks

Geoff

[pbaldy]

One way would be this, using this technique to filter the report and the code on the "looping" page to loop through the data, but exporting to PDF instead of emailing.

http://granite.ab.ca/access/email/re...recipients.htm