Unwanted Parameter! HELP!

  • Thread starter Thread starter MadCSS
  • Start date Start date
M

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!
 
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
 
Thank you, Roger! I was able to locate the problem and sucessfully fix it
based on the information you gave me.
 
Back
Top