Solved

Unwanted "Enter Parameter Value" prompt

Posted on 2013-01-14
4
942 Views
Last Modified: 2013-01-14
Hello,
Problem: I open a report and received an unwanted,  “Enter Parameter Value” prompt.

The below query is the RecordSource for a nested subReport.

The WHERE clause is referencing a text box (txtBookingsID) on the subreport that contains the subreport in question.

The reference to the text box is apparently correct in some sense, because after I click "OK" on the unwanted "Enter Parameter Value" prompt that pops up, my report opens and the data is all correct and could only be correct if the text box is referenced and the values read by the query. I don’t enter a value in the pop up “Enter Parameter Value” prompt, I just click on OK.

Can you help me figure out how to get rid of the prompt?

SELECT Equipment.Equipment_Description, Booking_Equipment.Bookings_ID

FROM Booking_Equipment INNER JOIN Equipment ON Booking_Equipment.Equipment_ID = Equipment.Equipment_ID

WHERE
Booking_Equipment.Bookings_ID = Reports!rpt_Booking_Sheet_All.Report!rpt­_Booking_Sheet_All_SubRpt_Container.Report!rpt_Booking_Sheet_All_SupRpt.Report!txtBookingsID;

Open in new window


Thank you!
Riverwalk
0
Comment
Question by:RiverWalk
  • 2
4 Comments
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 38776652
open report in design view

check the sorting or grouping that was set for the report..

also check the Filter property of the report from the Report's Properties window

what version of access are you using?

better if you can upload a copy of the db.
0
 
LVL 61

Accepted Solution

by:
mbizup earned 500 total points
ID: 38776664
It looks like your WHERE clause is simply linking ID fields between a parent and child report.

If that is the case, have you tried using Master-Child links instead of your WHERE clause?
0
 

Author Closing Comment

by:RiverWalk
ID: 38776734
mbizup -- using Master-Child links did the trick. Thank you very much.

Thank you too capricorn1, I check you points, and just so happens that those were not issues.

Wow! I R E A L L Y appreciate the help. I've been struggling with this for hours.

Thank you,
Riverwalk
0
 
LVL 61

Expert Comment

by:mbizup
ID: 38776747
Riverwalk -

Glad to help out.  If I'm not mistaken, the reason for your parameter prompt is that the subreport is not fully loaded at the time the parent report first needs that reference (or vice-versa).  Master-child links implicitly handle that timing for you so you don't get the prompt.
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …

733 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