Why am i getting this 'Enter parameter Value'?

A

Adnan

I have a form with row source from query, on this form I have a report that
open current record on report (as a work order), before then report opens I
get a 'Enter parameter Value' little window that asks me to enter a
tblTaskNumber.ID

How to I skip this, coze I do not want this to pop up!

Your help is greatly appreciated!
Adnan
 
B

Biz Enhancer

The popup is probably appearing because somewhere in either your form or
report you have a field that with a data source of "tblTaskNumber.ID" but it
is not in the query. It could also be a sortcode or header or footer
reference in the report. Either remove the field or reference, or add it to
the query.

Hope it helps,
Regards,
Nick.
 
A

Adnan

Biz,
I took all fields off of the form and queries and reports that are with row
source tblTaskNumbe.ID. I keep still getting the same pop up (if I click
Yes/No/Cancel it still opens the reports but I am looking ate removing it and
not popping up this thing)

v/r
Adnan
 
B

Biz Enhancer

There is still a reference to it somewhere. Try opening the report in design
view, from the main menu bar click "view" and then "Sorting and Grouping".
Check there are no references to the parameter in there. Also check for
criteria on your record source.

Does the report draw from the same query? If you have a stacked query ( one
query based on another) you may find the problem reference buried in a source
query.

Time for bed now so I will check the post in another 8 hours or so if you
haven't solved it by then.

Regards,
Nick.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top