When I close a form with DoCmd.Close I get a parameter popup

[Robert]

This is a repost. I will try to explain the problem a little better than I
did the last time.

When I execute DoCmd.Close on one of my forms I get one of those little
unknown parameter popups, the kind you get when there's something wrong with
your query. But all I'm trying to do is close the form, not read any data.
This popup appears to be gernerated by the row source query in a list box on
the form. This row source query references another text box on the form and
this appears to be what the popup is asking for. But there's a value in
this text box. And why should this query be executed when I'm closing the
form? How can I do DoCmd.Close without getting any parameter popups?

Robert

 

[RoyVidar]

This is a repost. I will try to explain the problem a little better
than I did the last time.

When I execute DoCmd.Close on one of my forms I get one of those
little unknown parameter popups, the kind you get when there's
something wrong with your query. But all I'm trying to do is close
the form, not read any data. This popup appears to be gernerated by
the row source query in a list box on the form. This row source
query references another text box on the form and this appears to be
what the popup is asking for. But there's a value in this text box.
And why should this query be executed when I'm closing the form?
How can I do DoCmd.Close without getting any parameter popups?

Robert

It might be this bug http://support.microsoft.com/?id=811860