Unwanted Parameter! HELP!

[MadCSS]

There is a parameter (Phone Number) that pops up every time I try to open a
related Form or Report. I changed this field at one point so that instead of
just Phone Number, there are now ¨Home Phone¨ and ¨Cell Phone¨ and am pretty
sure that is how things got messed up, but all I want to do is make the
little parameter box stop popping up! Have searched everywhere to see if I
left any of the original (Phone Number) fields, but cannot find one, and have
also looked in the actual parameter box, which is empty! Please help!

 

[Roger Carlson]

If your form or report has an SQL statement as the Record Source, removing
it from the base table will produce a parameter prompt. You should also see
if the field is in the Filter property of the form or report. In a report,
you can also have it in the Sorting and Grouping section, which will produce
a parameter prompt.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[MadCSS]

Thank you, Roger! I was able to locate the problem and sucessfully fix it
based on the information you gave me.