Solved

Unwanted "Enter Parameter Value" prompt

Posted on 2013-01-14
4
931 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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
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…

856 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