Mysterious "Enter parameter value" boxes

[DataMiner]

Okay, here's a puzzler: I have a form called "RunChartCenter" which is normally opened from form "MainSwitchBoard". RunChartCenter has , among other things, a place for users to enter "startdate" and "stopdate".

I just converted from Access 97 to 2002, and now, whenever I close RunChartCenter, I get pop-up "Enter parameter value" boxes asking me to enter forms!RunChartCenter!startdate and forms!RunChartCenter!stopdate.

If I just click "cancel", they go away and everything seems fine.

And here's a real mystery... if I close MainSwitchBoard before closeing RunChartCenter, I don't get the pop-up boxes.

This behavior is very repeatable in Access 2002, and does not occur in Access 97.

Any ideas?

 

[dungstar]

I've been having the same problem as well for months now. I thought I got rid of it but its back to haunt me. What I've noticed is that sometimes this problem does not reproduce itself consistently. I am developing a database as an Access 2000 file in Access 2002.

I have an Add form and an Edit form. I modeled the Edit form after the Add. When I load up the Edit form, sometimes it would ask for a "Enter parameter value" for a combo box control from the the Add form. When I close, I get a similar deal, only it asks for another set of controls from the Edit form, itself (and I'm closing the Edit form and the fields for which Access 2002 request values are already filled-in/populated and disabled).

If debug it and set a breakpoint at the DoCmd.Close line, then the prompt does not appear, but if I set a break point anywhere before or after, it does appear. I don't get it.

I thought I found the solution when I tried starting a new form from scratch and copying over the controls that did not have this problem, and then recreated the controls of the ones that did, then copying the VBA code onto those controls. See if that works for you.

If anyone else found a real solution for this, please help! Thanks.

 

[dungstar]

I'm working a different database and I still get these annoying "Enter Parameter Value" that has no effect on anything but to cause user confusion.

I think this is caused through changes in a query's structure that a form or report has once referenced. Even though it has been taken out, somewhere, there is still a trace of it.

Alternatives I've found to eradicate this problem is to unbound the form or report, then rebind it. Or you may have to do this with all objects. Or rebuild the entire form/report which can be very very tedious.

 

[JerichoSteele]

Found this link in another thread... http://support.microsoft.com/defaul...kb;EN-US;811860

 

[godofhell]

Can igther one of you post your database, I will like to see what you guys are getting. The times that I had similar things happen I found a field in my query had been removed and it created an EXPRESSION field referencing the old value. Cleaning out the Expression left by the field removal eliminated my problems.