access 2003 windows xo report

[Guest]

I deleted field nodds from my report. i also deleted it from my query. Now
when i go into my report i get the the message ENTER PARAMETER VALUE NODDS. I
cant find it nodds anywhere in my report. I did note when i deleted nodds
from my report it wasnt titled nodds it was titled text687. I think this
means i used it somewhere else in my report, but i dont think so and if so i
cant find it.
ANY HELP WOULD SURE BE APPRECIATED
thanks
ed

 

[Guest]

Thanks for the help. i did what you told me. There was nothing in Query
Parameters and the report sorting and grouping had 4 things in it and they
werent nodds.
Any more advise would be appreciated.

 

[Rick Brandt]

I deleted field nodds from my report. i also deleted it from my
query. Now when i go into my report i get the the message ENTER
PARAMETER VALUE NODDS. I cant find it nodds anywhere in my report. I
did note when i deleted nodds from my report it wasnt titled nodds it
was titled text687. I think this means i used it somewhere else in my
report, but i dont think so and if so i cant find it.
ANY HELP WOULD SURE BE APPRECIATED
thanks
ed

Probably in code or in sorting/grouping dialog. Where it can be hard to find is
if you have a control using it in an expression. If you struggle finding it the
easiest thing to do is copy the entire report and in the copy just start
deleting blocks of controls previewing between deletions until the parameter
prompt is gone. That should give you a fairly narrow place to look.

 

[Guest]

Thanks ill try copying and deleting
--
thanks

Probably in code or in sorting/grouping dialog. Where it can be hard to find is
if you have a control using it in an expression. If you struggle finding it the
easiest thing to do is copy the entire report and in the copy just start
deleting blocks of controls previewing between deletions until the parameter
prompt is gone. That should give you a fairly narrow place to look.