Enter Parameter Value ?? Huh?

  • Thread starter Thread starter Jolene
  • Start date Start date
J

Jolene

Hi There,
I made a report that I use quite often and because of
that, I have put it on our main switchboard, now I've done
this process before, but I must have done something wrong
this time because now when I go to open this particular
report (and only this one) it comes up with a
message "Enter Parameter Value" then it
says 'Query1.Company' and then a box for me to type
something, and then ok or cancel. Without typing
anything, I just push okay and it goes away and opens
fine, but I'd really like to get rid of this box so as not
to confuse others working with this report. Is there any
way to get rid of it, or please tell me what I did wrong
and how to fix it.
Thanks so much.
 
Hi There,
I made a report that I use quite often and because of
that, I have put it on our main switchboard, now I've done
this process before, but I must have done something wrong
this time because now when I go to open this particular
report (and only this one) it comes up with a
message "Enter Parameter Value" then it
says 'Query1.Company' and then a box for me to type
something, and then ok or cancel. Without typing
anything, I just push okay and it goes away and opens
fine, but I'd really like to get rid of this box so as not
to confuse others working with this report. Is there any
way to get rid of it, or please tell me what I did wrong
and how to fix it.
Thanks so much.
Click to expand...

Somewhere in your report you once had a reference to the [Company]
field in the query1 that has since been deleted. Perhaps you still
have a reference to it in the Report's Sorting and Grouping dialog
(that's the 'usual' culprit. ;-) ). Or you might still have a
reference to it in a VBA code module, or in a control source in your
report.
 
Back
Top