Is there any way that I can close an MsQuery Window by VBA?

I have code with some DDE commands that opens an MSQuery and executes a
query. That opens a window called Query1 in MsQuery. I want to be able
to close the Query1 window in Msquery without closing MsQuery itself.

Thanks
Brian

BerkshireGuy wrote:[color=blue]
> Is there any way that I can close an MsQuery Window by VBA?
>
> I have code with some DDE commands that opens an MSQuery and executes a
> query. That opens a window called Query1 in MsQuery. I want to be able
> to close the Query1 window in Msquery without closing MsQuery itself.
>
> Thanks
> Brian[/color]

You can use docmd.Close acQuery, "queryname". You can also open the
query in a recordset so that you can use the data behind the scenes. I
am not sure what you are trying to do.

Thanks Collen,

MSquery is a seperate application that I am opening with access using
DDECommands. However, I cannot figure how to close it out without the
user click on the X button.

-Brian