<div>
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....<br />
<br />
you want the user to see a table but not edit its data?:<br />
<br />
DoCmd.OpenQuery &quot;myname&quot;, acViewNormal, acReadOnly
</div>


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

<div>
<div class="content wysiwyg-content">
I need to open an query in table form from an event proceedure on a form. &nbsp;The query needs to be in the table form as if opened by double clicking the query name in the db window.
</div>
</div>


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.

VB to Open a Query in an Evcent Proceedure

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.