By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,327 Members | 1,789 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,327 IT Pros & Developers. It's quick & easy.

Help Regarding Query

P: 48
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.

Dec 6 '07 #1
Share this Question
Share on Google+
2 Replies

Expert Mod 10K+
P: 12,392
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.
Dec 6 '07 #2

P: 4
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
Dec 6 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.