Results 1 to 2 of 2
  1. #1
    MelonFuel is offline Novice
    Windows XP Access 2007
    Join Date
    Jun 2012
    Posts
    28

    How can i get vba to get a value from a combobox and make it run a macro

    Hi




    How can i get vba to do this.


    When i click a button on the main form the vba code will execute and get the value from the combobox ie TE4700 and locate the macro with the same name ie TE4700 with reports in then it will run the macro and print off the reports.


    This is what the macro looks like:-


    Click image for larger version. 

Name:	macro.PNG 
Views:	9 
Size:	32.9 KB 
ID:	9072


    Thanks MelonFuel

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,640
    Untested, but along the lines of:

    DoCmd.RunMacro Me.ComboName
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 06-25-2012, 02:15 PM
  2. Macro to make record read-only
    By Sketchin in forum Forms
    Replies: 1
    Last Post: 02-10-2012, 05:57 PM
  3. help to make a macro?
    By d3vil112 in forum Access
    Replies: 6
    Last Post: 05-08-2011, 12:55 AM
  4. Replies: 0
    Last Post: 08-24-2010, 06:38 PM
  5. How to make A combobox run a query?
    By UnrealEnvy in forum Access
    Replies: 8
    Last Post: 08-17-2009, 11:28 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums