Problem with macro action GoToRecord

[jonniv]

I have created macro to create multiple pdf files automatically. I have form with multiple records. An idea of the macro is to first manually select the first record and run the macro, which opens the report -> creates pdf file -> closes the report -> goes to next record -> start macro from begin again.

My macro first opens the certain report based on the data in record. And then creates pdf and names the file based on the field [Docref] -> ="C:\temp\"+[Docref]+".pdf"

My problem with this macro is that after the GoToRecord action, macro still picks up [Docref] field information from the first record.. And this means that macro creates the pdf file only from the first record because filename already exists.. Macro runs throught all the records, but in the end there is only file (pdf of the first record) in c\temp -folder.

Any ideas to help me with this macro?

Thanks in advance.

 

[Uncle Gizmo]

I don't think this thread will be of much help to you as it's done with VBA not macros, but I thought you should be aware of it, it might provide some inspiration.

HERE:- Form saving several reports in one go (As PDF)

Videos and a presentation available at comments:- #3 #19 #20 #23