Request for Parameter - where coming from?

J

John H W

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
 
J

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
 
B

Brook

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

Have a great day..

Brook
 
F

fredg

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.
 
B

Brook

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
 
Top