Enter Parameter Value??

[tempestes]

Hi there,

I re-vamped an old form and now am ready to enter my data, but when I opened up the form today (after working on it yesterday), it is giving me the message Enter Parameter Value, then says Label556 with a field for entry below that.

My form doesn't have a Label556. It did, but I deleted it. Because first the message was Label1. Which I didn't also have so I thought I could delete and re-add the applicable field to the form and get rid of the error.

So much for that. What the heck is Access trying to tell me?? I can X it out and continue on the form, but that's not clean!

Thanks!
Lynne

 

[Mr. B]

Evidently your form is using a query or an sql statement as its record source. The prompt for a parameter will appear when there is a field in the record source that cannot be resolved.

It sounds a little strange but it really sounds like the record source may actually have a parameter set to look at the now non-existant label control.

 

[vbaInet]

Places (I can think of) to look in:

* Record Source property of the form
* Filter property of the form
* Order By property of the form
* Row Source property of all the list boxes and combo boxes
* Code

 

[boblarson]

One more alternative - could be referenced by a control's control source possibly.