Exportwithformatting - getting filename from the value in a field in the report (1 Viewer)

[JimOR]

I have a macro that brings up one selected page at a time and I want to save this as a pdf with a filename from a field "Invoice Ref" on the form. I have attached a screen shot. Ignore the SetVar bit - that was somenting I saw on one of the other posts, but it didn't work.
This macro will export the file but with the filename "[Invoice Ref]" I have tried all combinations of [ ] and ([ ]) without success. How can I specify that [Invoice Ref] is a value? No VBA please!

 

[Gasman]

In VBA you would concatenate the control value using &

I cannot get same to work in a 2007 macro, which I hardly ever use anyway.

Better get used to using VBA. Much more flexible than macros, and easier to use.

 

[Gasman]

This works

I just set a Tempvar as a test for a variable. You can use the form control with full form reference.

 

[JimOR]

Sorry for the delay in responding, Gasman; a few things got in the way I have adapted my macro (see attachment) The result is that the Save dialogue box pops up. As the relevant record is also opened, it is easy enough to enter the Invoice Ref as the file name. Not perfect, but it will do for now. Can you see where I am going wrong?
Thanks for taking the time to help me. I have as started to look at VBA code but it's still very early days
Jim

 

[Gasman]

I hardly ever use macros.
I also do not use spaces in tempvar names.
You set tempvar InvoiceRef, so use that in the output file field.
If you need a path, concatenate the tempvar value to the path.
I doubt Ready To Print is in the name of the report?