calling a query

[Anakin Moonwalker]

How do I call a query by clicking on a button in a form?

Thanks!
Ron

 

[Van T. Dinh]

Which kind of Query you want to "call"?

A Select Query returns rows while an Action Query performs some action but
does not return any row.

Check Access VB Help on the OpenQuery Method of the DoCmd object.

 

[Anakin Moonwalker]

Thanks! I was just trying to open a standard query (not sure what other kinds
of queries there are).

DoCmd.OpenQuery "Query" works!

Thanks again!

 

[Anakin Moonwalker]

Thanks!

Which kind of Query you want to "call"?

A Select Query returns rows while an Action Query performs some action but
does not return any row.

Check Access VB Help on the OpenQuery Method of the DoCmd object.