Trying to save a filter as query

[melaniews]

This is what I have so far (in the unload event). My problem is the saveasquery command prompts for a filename and I can't figure out how or where to put the text and click the OK button. It will also prompt me that the file already exists and do I want to save anyway.

Also I'm not sure of how to use the echo command but would like this all to be invisible.



DoCmd.RunCommand acCmdFilterByForm
DoCmd.RunCommand acCmdSaveAsQuery


DoCmd.Close



All help here would be appreciated.

TIA,
Melanie