Page Header - pass a variable

M

MartyO

I would like to pass the resource name that the user selects from the "Using
Resource" dialog box when my report runs, to the strUserName varialbe in the
code below. Can I do that? Can I capture that info or do I have to build my
own form?

Dim strUserName
strUserName = "MartyO"
FilePageSetupHeader Name:="myToDoList", Text:="&[Report] as of &[Date]"
& Chr$(10) & "&[Project Title]" & Chr$(10) & strUserName
ReportPrintPreview Name:="myToDoList"

Thanks in advance!
Marty
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top