<div>
<div class="content wysiwyg-content">
Hi.<br />
<br />
I am using Access 2010<br />
<br />
I have a form and a report.<br />
<br />
From the form, &nbsp;I can use the following code and it works fine.<br />
<br />
'DoCmd.OpenReport &quot;Report&quot;, acViewPreview, , &quot;[Packing Slip Ref Num]= '&quot; &amp;&nbsp;Me.[Packing Slip Ref Num] &amp;&nbsp;&quot;'&quot;<br />
<br />
<br />
I am having trouble in figuring out how to pass a string value to the &quot;Report Open Event&quot; &nbsp;so that I can affect the Report Header text.<br />
<br />
I appreciate any help.
</div>
</div>


Hi.

I am using Access 2010

I have a form and a report.

From the form,  I can use the following code and it works fine.

'DoCmd.OpenReport "Report", acViewPreview, , "[Packing Slip Ref Num]= '" & Me.[Packing Slip Ref Num] & "'"


I am having trouble in figuring out how to pass a string value to the "Report Open Event"  so that I can affect the Report Header text.

I appreciate any help.

access 2010 form    DoCmd.OpenReport with argument

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.