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

why does my run query command button not work?

P: 1
I am trying to run a query from a form using a "run query" coomand button. The query fails to run, though it does open. The run query button works from the the design view of the query, but not from the linked form. How can I get the button to run the query?
Dec 16 '19 #1
Share this Question
Share on Google+
2 Replies

Expert Mod 2.5K+
P: 3,328

Welcome to Bytes!

Unfortunately you will have to provide us a bit more information.

Please provide the VBA code you are using and any additional information about the query that might be helpful. Also, if you are getting any error messages, this would also be helpful.

Thank you!
Dec 16 '19 #2

P: 65
"Run query" is for action queries.
It sounds like you try to open a select query. So, use
Expand|Select|Wrap|Line Numbers
  1. DoCmd.OpenQuery
for that.
Dec 17 '19 #3

Post your reply

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