Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2002
    Location
    Houston, TX
    Posts
    116

    Question Unanswered: Macro - query - form

    I need some help with a macro problem. I have a form that has a drop-down box that a user will select what query to run. There is a button on the form that will run the query based on the selection of the drop-down box. ????I'm lost here. I know how to write the macro to run a specific macro, but not how to based on variables. (e.g. Query 1, or query 2, or query 3, etc) Please help

    texasalynn

  2. #2
    Join Date
    Aug 2002
    Location
    Charlotte NC
    Posts
    665
    I would write an if then statment in vba that said
    if combo1 = 'query1'
    then docmd.runmacro
    if...
    end if

    Just a thought
    Jim

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •