?
Solved

How to stop parameter prompt in Access

Posted on 2015-01-22
5
Medium Priority
?
178 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 58

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 1000 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 48

Expert Comment

by:Dale Fye
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 1000 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 58
ID: 40579516
Glad to hear your set.

Jim.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

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

Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
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 how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
Suggested Courses

764 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