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

Select Case as macro

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
0
PatKung
Asked:
PatKung
  • 2
1 Solution
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
I *think* ... that in A2007, something like this can now be done.  I don't have A2007 loaded at the moment.

mx
0
 
GRayLCommented:
Why not use the macro to RunCode?  And the function named in RunCode has the Select Case?
0
 
PatKungAuthor Commented:
That should work.  

Thanks, Pat
0
 
GRayLCommented:
Thanks, glad to help.

Ray
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

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