Enter Parameter Value error (1 Viewer)

S

ssworthi

Registered User.

Local time

Yesterday, 22:07

Joined

Jun 9, 2010

Messages

97

• Jun 11, 2010

• #1

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.

 

V

vbaInet

AWF VIP

Local time

Today, 06:07

Joined

Jan 22, 2010

Messages

26,374

• Jun 11, 2010

• #2

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

 

S

ssworthi

Registered User.

Local time

Yesterday, 22:07

Joined

Jun 9, 2010

Messages

97

• Jun 11, 2010

• #3

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?

 

V

vbaInet

AWF VIP

Local time

Today, 06:07

Joined

Jan 22, 2010

Messages

26,374

• Jun 11, 2010

• #4

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.

 

S

ssworthi

Registered User.

Local time

Yesterday, 22:07

Joined

Jun 9, 2010

Messages

97

• Jun 11, 2010

• #5

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

 

V

vbaInet

AWF VIP

Local time

Today, 06:07

Joined

Jan 22, 2010

Messages

26,374

• Jun 11, 2010

• #6

You're welcome