Which Report is OPEN - Return Report Name

[moolie]

I have built a GhostScript PDF generator and have it working. Now I need to incorporate it into macro that can be accessed from a Custom Menu Bar.

Everything works except for the missing piece of the puzzle:

A report is opened and the user presses the PDF button on the menu bar. I need code that gets the name or title of the Open Report. I can then pass that to the PDF generator to finish the task.

IS there a docmd.?? that gets the name of the open report?
Or some other code to do the same thing?

 

[PHV]

In VBA you may try Application.Reports(0).Name

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[lupins46]

If you only have ONE report open at a time then you can use:

Reports(0).Name

to get its name.

 

[moolie]

Did the trick

thank you.