Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 344
  • Last Modified:

VB to Open a Query in an Evcent Proceedure

I need to open an query in table form from an event proceedure on a form.  The query needs to be in the table form as if opened by double clicking the query name in the db window.
1 Solution
DoCmd.OpenQuery "MyQueryName"
Simon BallCommented:
as shane says above.. but tere are lots of other options you can tie in at the end... the mode the table opens in, and the edit mode for the data....

you want the user to see a table but not edit its data?:

DoCmd.OpenQuery "myname", acViewNormal, acReadOnly

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now