close form - parameter request pops up

[bpauley]

Hello All,
I have a problem when I close a form. I am getting a popup asking for the
parameters in a query that filters info for a combo box on the form. I am
closing the form with a command button. This is the code behind the command
button.
```````````````````````````````````````````````
Private Sub cmdCloseCurrentfrm_Click()
On Error GoTo Err_cmdCloseCurrentfrm_Click

DoCmd.Close

Exit_cmdCloseCurrentfrm_Click:
Exit Sub

Err_cmdCloseCurrentfrm_Click:
MsgBox Err.Description
Resume Exit_cmdCloseCurrentfrm_Click

End Sub

````````````````````````````````````````````````
If I close the from with the X in the top right corner, I get no popup for
the parameters. Same if I use the close by going to "file", "close".
How do I eliminate the popup from displaying when closing the form?
Thank you
Bill

 

[Gina Whipp]

BPauley,

Going to need a wee bit more information... Can you post the SQL of the
query the combo box is using and the parameter the error message is asking
for?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[bpauley]

Hello Gina,
Thanks for your reply.
I have found a thread involving the same type question that I had. Marshall
Barton replied to a poster with a microsoft kb article. I read the article
and added two lines of code to the command button that closes the form.
DoCmd.Echo.False then true after the close line.

It is as follows
``````````````````````````
Private Sub cmdCloseCurrentfrm_Click()
On Error GoTo Err_cmdCloseCurrentfrm_Click
DoCmd.Echo False
DoCmd.Close
DoCmd.Echo True

Exit_cmdCloseCurrentfrm_Click:
Exit Sub

Err_cmdCloseCurrentfrm_Click:
MsgBox Err.Description
Resume Exit_cmdCloseCurrentfrm_Click

End Sub

``````````````````````````````````````````

It cured the problem.
Here is the ms kb article Marshall referred to.
http://support.microsoft.com/kb/811860/en-us
Thank you
Bill

 

[Gina Whipp]

Thanks for posting back... Glad Marshall's posting help!

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm