Solved

How to stop parameter prompt in Access

Posted on 2015-01-22
5
165 Views
Last Modified: 2015-01-30
Hi, I'm relatively new to database creation and am using MS Access 2013.

My database: Users fill out a form (Parameters_InvoiceRpt) to filter results to open a report (InvoiceHrgs) via a macro (MacroInvoiceRpt).  Report's record source is a query (Invoice Query).

When I run my report, I keep getting a Parameter question box asking for the value of "Courthouse".  Courthouse is a value found in the "Counties" table and is not used in this query, form, or report.  So why is Access prompting me for it and how do I get rid of this?

DB is uploaded to assist you.  Relevant titles are referenced above.

thanks!
Haba-Law-Firm.accdb
0
Comment
Question by:Lisa Haba
5 Comments
 
LVL 57

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 250 total points
ID: 40564011
Whenever you get a prompt, it means that Access can't figure out what your referring to.  Look for table and field name mis-spellings, not including it in the objects recordsource, etc.

In reports, often where there is a problem is in the sorting and grouping options where you refer to a field that is no longer available.

OrderBy and FilterBy are two other properties where something may be referred to but not available.

Jim.
0
 
LVL 47

Expert Comment

by:Dale Fye (Access MVP)
ID: 40564190
And check to make sure you have not actually defined a parameter for a query.  This can happen when you copy a query and then modify it.  If you defined a parameter for the query, it will show up as the first line in the SQL view of the query.
0
 
LVL 74

Assisted Solution

by:Jeffrey Coachman
Jeffrey Coachman earned 250 total points
ID: 40564251
<No Points wanted>

You did not post the specific instructions on how to see this issue in your database...

But I dug a little, and what Jim said is true...

You have set up a sort for "Courthouse",...in the report's Sorting and Grouping options...
Remove this sort and the prompt should go away...

JeffCoachman
JeffCoachman
0
 

Author Closing Comment

by:Lisa Haba
ID: 40579479
Thanks for the help - that did it!
0
 
LVL 57
ID: 40579516
Glad to hear your set.

Jim.
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

Suggested Solutions

I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
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 …
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…

911 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

24 Experts available now in Live!

Get 1:1 Help Now