[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 196
  • Last Modified:

How to stop parameter prompt in Access

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
Lisa Haba
Asked:
Lisa Haba
2 Solutions
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
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
 
Dale FyeCommented:
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
 
Jeffrey CoachmanMIS LiasonCommented:
<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
 
Lisa HabaAuthor Commented:
Thanks for the help - that did it!
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
Glad to hear your set.

Jim.
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now