<div>
I *think* ... that in A2007, something like this can now be done. &nbsp;I don't have A2007 loaded at the moment.<br />
<br />
mx
</div>


I *think* ... that in A2007, something like this can now be done.  I don't have A2007 loaded at the moment.

mx

<div>
That should work. &nbsp;<br />
<br />
Thanks, Pat
</div>


<div>
Thanks, glad to help.<br />
<br />
Ray<br />

</div>


<div>
<div class="content wysiwyg-content">
Is there a way to do Select Case in a Macro? &nbsp;Or if I Have a message saying do you want to run this and they say not it will stop the rest of the macro from running?<br />
<br />
2007 is createing macro when I create a button to run a query, but I am not real sure how to do some of the things I used to do in code. &nbsp;<br />
<br />
Thanks, Pat
</div>
</div>


Is there a way to do Select Case in a Macro?  Or if I Have a message saying do you want to run this and they say not it will stop the rest of the macro from running?

2007 is createing macro when I create a button to run a query, but I am not real sure how to do some of the things I used to do in code.  

Thanks, Pat

Select Case as macro

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.