Solved

Enter parameter value when printing

Posted on 2013-05-14
2
373 Views
Last Modified: 2013-05-14
Hello experts! I have a problem I have been struggling with for a while and can't find what is missing. I have set up a pretty simple database to enter some orders for our trade show shipments. When a new order is entered, I need it to print out the report for just that new order.

However, when I hit the "Print" button, it asks for the parameter value for printing. Even if I put in the right order number, it still will print all of them in the database.

I have set this up on several other databases and it works perfectly. I think I have some issues with the references or relationships, maybe, that are making it not work right, as I have mirrored exactly what I've done before. On this one, though, it just isn't working right and I cannot figure out what is wrong.

I have attached the complete DB as I figured that would be a lot easier than trying to describe what all I've done in the setup.

Thanks in advance for any help anybody can give me.....I'm hoping there is something simple that I just cannot see.

Robert Monroe
Trade-Show.accdb
0
Comment
Question by:rkm360
2 Comments
 
LVL 119

Accepted Solution

by:
Rey Obrero earned 500 total points
ID: 39164981
open your report in design view then hit F4
look in the Data tab and delete the content of the Filter Property
then save the report

in your code that opens the report

change this line

    DoCmd.OpenReport "Trade Show Orders", acViewNormal, "", "[Trade_Show_Orders_OrderID]=[Forms]![Trade_Show_Orders_Enter]![OrderID]", acNormal


with


     DoCmd.OpenReport "Trade Show Orders", acViewNormal, "", "[Trade Show Orders_OrderID]=" & Me.OrderID, acNormal




.
Trade-Show.accdb
0
 

Author Closing Comment

by:rkm360
ID: 39165499
Thank you very much!! This worked perfectly. I knew there was something I was missing and it's been driving me nuts. Thank you so much for your help!

Robert
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

No matter the version of Windows you are using, you may have some problems with Windows Search running too slow or possibly not running at all. Before jumping into how you can solve this issue, just know there are many other viable alternative deskt…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

705 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now