Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


Subreport prompting for parameter value

Subreport prompting for parameter value

Subreport prompting for parameter value

Hello all--

I am using an MS Access Project (.adp) and connecting to an MSDE database.

I have an issue with a report which contains multiple subreports.  The record source for the main report is based off of a stored procedure.  Each subreport also uses a different stored procedure.

When I launch the main report, I am prompted to enter a parameter value for the main report and all of the subreports.  So, if I have a report that has 5 subreports, I will be prompted for a value 6 times.  

I would like the ability to enter the parameter once for the main report and then have it applied to the parameters of the subreports.

If someone out there knows how to make this work, please help!!! as I'm at the end of my rope with this report.

Much Thanks.

An Amatuer

RE: Subreport prompting for parameter value

if all the subreports are in the same section then
make sure that the parameter in all the stored procedures have the same name
i.e. @Customerid

place a text box on the report that the control source has the same name as the parameter  without the @

put the parameter  in the select statment of the main stored procedure @Customerid as Customerid if you not alreday  Selecting this value

RE: Subreport prompting for parameter value

Hey pwise,

Sorry for the late response on this thread.  I had to put this project on the back burner as some other project took precedence (You know how that goes).

Anyway, I followed the steps you provided and the report works like a charm.  

I do want to thank you for providing some much needed insight.


Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close