Request for Parameter - where coming from?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report that gets data from 4 tables:
Table 1: Attendance
Table 2: Customers
Table 3: Introduction
Table 4: Employment

On Report_Open, in VB, I execute a query getting data from Table 1 and the
Name from Table 2 based on a customer number (the link between the two
tables). I then store this info in global variables for later use, then based
on this info get data from Tables 3 and 4, which are also stored in global
variables.

On leaving Report_Open, and before I it gets to any other event in the
report (as far as I can tell since I have put msgboxes in all other events
and functions and none of them fires), I get an input box requesting a "Name"
(no matter what I put in that box, it errors out). The word "Name" is not
used anywhere else in the report except in a Label (which I changed to
"Client Name", but the input box still had Name.) I have also checked all
queries and none of them has anything to do with Name that is not associated
with something else (a field name is always associated with a table, etc.)

Where is this request for a pointer coming from? The box title is
"Customer" but I can find no instance in the form or table "Customer" where a
"Name" would fire a request.

I am stumped. Any pointers on where I might look for this request

John H W
 
Thanks for the reply.

Believe it or not, I went to do something else that had nothing to do with
the report (working on something completely different in the DB), then when I
went back, it was no longer asking for the parameter. If it comes back, I
will try this.

John
 
So where did you go? Maybe I will try that b/c I'm still getting the message?

Have a great day..

Brook
 
So where did you go? Maybe I will try that b/c I'm still getting the message?

Have a great day..

Brook
Click to expand...

The usual culprit when getting a parameter prompt in a report for a
value that is not in the report is the Report's Sorting and Grouping
dialog.
At one time you may have had a field in the sorting and grouping that
you have since deleted, and forgotten to remove the reference to it
there.
 
Fred...

Thanks for the tip, the ony thing is, is that I have even tried to recreate
the qry, rpt, and frm and still get the same thing, "enter parameter Value"?

Brook
 
Back
Top