Access Report ExportWithFormatting Output PDF File name to include field from List Box

[pattyjean]

Access 2010
I am using a list box to export with formatting report to PDF but I would like to include the selected item from the list box into the final report path name. Is this possible?
Thank you for your review.

 

[guitarzan]

If you are looking for a vbscript solution, you should post the code that you have. Otherwise, you might be better off posting in one of the Access forums

 

[pattyjean]

I realized that I posted it in the wrong forum but I believe it needs to be a vbscript solution, and I don't know how to start it.

 

[pattyjean]

L:\Scorecards\Academic Affairs\Cohort Retention\Fall Cohorts\OUTPUT\Fall-Cohort & "\" & Me.Term & ".pdf"

I don't know what to put at teh Me.Term - that is the field value but the name of the list box is lstTerm.