Help Regarding Query

[manoj9849967222]

Hi All

I have a form which contains a command button"Command1 " which is linked to a query. When i click the command button it executes the query.

Now i want that the Query should close automatically after execution.

I am unable to write the code for this. Can any one please help.


Regards
Manoj

[Rabbit]

Why would you want that? Opening and Closing a query does almost nothing. Why open a query if the user's never going to see it? Since it's showing results, I assume it's not an action query so I don't see the purpose of this.

[owyn999]

Actually this sounds like a problem that would be given in a college class, it sounds to me that this button is supposed to open a query, generate a set of results and then end the query, not that it matters but the easiest way to "close" a query is to just set the query statement to Null