Solved

Pass two open args to a REPORT in ACCESS 2003

Posted on 2013-01-18
3
368 Views
Last Modified: 2013-01-18
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
0
Comment
Question by:ssmith94015
  • 2
3 Comments
 
LVL 29

Accepted Solution

by:
IrogSinta earned 500 total points
ID: 38795165
Well if the form is still open, you can just refer  straight back to the controls on your form like so:
= Forms!NameOfForm!txtEvalYear

This could go in your code or it can be the expression in the control source of your textbox in the report.
0
 
LVL 29

Expert Comment

by:IrogSinta
ID: 38795180
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.
0
 

Author Closing Comment

by:ssmith94015
ID: 38795189
That did it and was simple, thank you.

Sandra
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The new Microsoft OS looks great, is easier than ever to upgrade to, it is even free.  So what's the catch?  If you don't change the privacy settings, Microsoft will, in accordance with the (EULA) you clicked okay to without reading, collect all the…
Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question