Enter Parameter Value error

[ssworthi]

When opening my form I get an "enter Parameter Value" dialog box for a field that is no longer part of the form . This must be in a form query I am guessing; what is the quickest way to find out where it is looking for it?
Thanks in advance for any help.

 

[vbaInet]

Try looking in the Record Source property of your form and open the query by clicking the elipsis (...) button.

 

[ssworthi]

You mean the black box on the left top in design view where it lists all the properties of the form? I open that up and the ALL tab does not appear to reflect any queries. I went through each field listed in the top dialog box listing all the fields and can't find that field that it's asking for. Could it be in a query not related to the form?

 

[vbaInet]

Yes the little black box. Now, click on the DATA tab, and look for the RECORD SOURCE property. You will see a small button that will appear in that box, click on it and the QUERY DESIGN GRID will come up.

 

[ssworthi]

I can't believe it; wow! That was it! Thank you so much!

 

[vbaInet]

You're welcome