Problem calling a query from a form command statement

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hello,
I am trying to call a query from a form control Command1

in the code I have the following statement

DoCmd.OpenQuery "q_myquery"

where q_myquery is the exact name of the query. I know it is exact because
I copied and pasted it from the query name into the statement.

This statement returns an error with no message

what is the most likely problem, and what can I do about it?

Thank you,

keith
 
Things to check:
Can you open the query independently of the command?
Is the query already open (in design mode)?
Compact and repair your database.
 
Thank you very much. This was helpful.
Keith

kingston via AccessMonster.com said:
Things to check:
Can you open the query independently of the command?
Is the query already open (in design mode)?
Compact and repair your database.
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Refreshing a query 1
Problem displaying a form that runs queries 4
Opening a query from a command button 2
Query problem 8
Pass a control.value to SQL statement?? 4
SELECT FROM Query name 1
VB - Display SQL Statement from Query 4
Multi-Selection Code review 2

Back
Top