naming my report (1 Viewer)

murray83

Games Collector
Local time
Today, 05:16
Joined
Mar 31, 2017
Messages
728
hopefully quite an easy fix

at the moment my report is named thus

Code:
strReportName = "System Handover" & " " & todayDate & ".pdf"


how ever i would like to change the section with todayDate to what the user inputs for the query to work have tried this

Code:
    strReportName = "System Handover" & " " & Table2!DT & ".pdf"

but i get an error; run time error 424 object required

any ideas please
 

Ranman256

Well-known member
Local time
Today, 01:16
Joined
Apr 9, 2015
Messages
4,339
dont put the report name in the query, (params)
instead make a form, the user enters the name in the text box,
THEN create the name:
strReportName = "System Handover " & txtDT & ".pdf"
 

Users who are viewing this thread

Top Bottom