<div>
If you did want to go the OpenArgs way, you would need to combine your strings into a single string first and assign it to OpenArgs. &nbsp;Then in your report you would need to add code to parse the string into its components. &nbsp;The previous method I mentioned is simpler.
</div>


If you did want to go the OpenArgs way, you would need to combine your strings into a single string first and assign it to OpenArgs.  Then in your report you would need to add code to parse the string into its components.  The previous method I mentioned is simpler.

<div>
That did it and was simple, thank you.<br />
<br />
Sandra
</div>


That did it and was simple, thank you.

Sandra

<div>
<div class="content wysiwyg-content">
I have a form whereby users select a year and a quarter and run the report. &nbsp;I want these two values to populate two text fields on the report. &nbsp;I am trying to use opening argu, but I am not gettng anywhere. &nbsp;Teh questions marks are where I want the values from txtEvalYear and txtEvalQuarter to go so they appear on the report.<br />
<br />
&nbsp; &nbsp; DoCmd.OpenReport &quot;rptDataSourceRankingCount<wbr />s&quot;, acPreview, , , acWindowNormal,????<br />
<br />
Sandra
</div>
</div>


I have a form whereby users select a year and a quarter and run the report.  I want these two values to populate two text fields on the report.  I am trying to use opening argu, but I am not gettng anywhere.  Teh questions marks are where I want the values from txtEvalYear and txtEvalQuarter to go so they appear on the report.

    DoCmd.OpenReport "rptDataSourceRankingCounts", acPreview, , , acWindowNormal,????

Sandra

Pass two open args to a REPORT in ACCESS 2003

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

Microsoft Applications

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.

Microsoft Development

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.