Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

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

Status
Not open for further replies.

pattyjean

Technical User
Mar 3, 2006
53
US
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.
 
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.
 
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top