Populating unbound text box on a report

[ontopofmalvern]

Hi when I run this code on an open Form the unbound text box called "txtBox" gets filled with the word "bob"

Forms!frmMyForm!txtBox = "bob"

but when I run this on an open Report

Reports!rptMyReprt!txtBox = "bob"

I get the error "Argument not optional" (also VBA editor changes "Reports!" to "reports!" which I think is a clue ..)

I have a nasty workaround for my current problem using TempVars to pass the value to the Report then having an onload event like this

Me.txtBox = TempVars!strText

There must be a better way which I feel must be dead obvious but I can't find it.

 

[theDBguy]

Hi. Not in front of a computer now, so I could be wrong, but I think reports can't usually be changed once it's already rendered, not like forms, which are dynamic objects.

 

[CJ_London]

rather than using tempvars, you can use the openargs parameter for docmd.openreport. AS DBG say, reports are not dynamic once opened. As you have discovered you need to use report events to modify report contents.

 

[ontopofmalvern]

Many thanks, that makes sense now and is obvious (isn't always once you know?)

Couldn't get openargs to work, I don't think I have the syntax right, if my control is called "txtBox" and report "rptMyReport"
what do I replace "??" with below?

DoCmd.OpenReport "rptMyReport", acViewReport, "", "", acNormal, "??"

 

[CJ_London]

DoCmd.OpenReport "rptMyReport", acViewReport, "", "", acNormal, "bob"

and in the form open or load event

me.txtBox=openargs

 

[ontopofmalvern]

Many thanks for all the helpful tips here. Especially useful is the difference between ReportView and PrintView, never really considered it before.