Solved

How to stop parameter prompt in Access

Posted on 2015-01-22
5
172 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Linking Child/Parent fields between 2 subforms 15 57
Access lists formating 8 44
MS Access query 16 54
What are the recommended security measures to put in place? 19 85
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

739 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