Disabling Parameter Dialog Box

[ASMProComp]

Hello,
I have an innoccuous problem with a report I run in Access. The record source for the report is a query that is pulls data from 6 tables. I have a table titled ARInfo that I have to return amost all the fields in the table (big table) so I used * and show all the fields. When I run the report from the button click event on my form, before the query runs that servers as the report's record source, a parameter dialog box pops up titled ARInfo (table name). You do not have to enter anything in the box for the report to run properly. I have only been with the company or 3 months, but we have used Aceess 97 and Access 2000 in the past and it is my understanding that in the old systems, this dialog would not pop up (The query, form, report, and code is unchanged0. Since we converted to Access 2002, this dialog pops up. The code behind the form, report, and in the associated modules is very immense (This report and form that drives it touches many diferent pieces of the system) so I'm not really about to inclued any code in this post. If anybody knows a quick and dirty trick to disable dialogs or any conceptual theories as to why this is occuring, please let me know.
Andrew

 

[RuralGuy]

If the report is based on a static query then run the query by itself and see if you can spot the problem. That issue usually means something (a field name maybe) is not spelled correctly.

 

[john471]

You stated the dialogue box was "titled 'ARInfo'" which you said was the name of one of the source tables. Is there anything else in the dialogue box?

Also, if you can run the query directly without getting the popup, the problem may lie in the sorting/grouping specifications of the report.