Splitting Access Report into separate PDF files and renaming with the group name

[maec87]

I have an Access Report that is grouped by Account Number. I can export to a PDF file but I would like to have this large PDF file split into individual PDF files. The naming convention for the newly created PDF files would be the actual account number. I would like to have them saved in a folder on my desktop called, "PackingLis ts".

I am using Access 2007. I have very limited knowledge of VBA so in any response, I would need some of the elementary details the seasoned programmers would not need.

Thank you so much
Maureen

[zmbd]

There's no simple way of doing this for seperate pdf files.
You might be able to alter the following to suit:
split by company grouping

[maec87]

Since I am new at doing VBA, where would this code be placed? Would I open up my report in design view, select view code and then key in the module or do I do it on the on load or on current of the property sheet for that report?

Again, thank you for responding