Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2005
    Location
    Brooklyn, ny
    Posts
    69

    Unanswered: Form to run a query (dropdown box)?

    Hello,
    I have a form that runs 3 make table query, and then I have a final query which I have to run manually since I need to change the account id each time I run it. (about 20 id’s)

    Is there are a way to attach this query to a form code and have a drop down box from where I may choose the account id and than run the query, result of which will be outputted to a dir on my pc.?

    Please help me out, I never done that before.
    Really appreciated

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Have a look at DoCmd.OutputTo
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  3. #3
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,424
    Provided Answers: 8
    if you point the where part of the Query to the combo box in the form

    then when run the query it will read the combo box

    The Criteria of the query should look something like
    Forms![Keywords Builder]![CBOMainList]

    a tick i use is open the form in question then right click in in the Criteria of the query and click the Build .. just drill down to what you want.

    then to give it a brain

    in the


    Private Sub CBOMainList_AfterUpdate()
    docmd.dosomething
    End Sub
    hope this help

    See clear as mud


    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

  4. #4
    Join Date
    Sep 2005
    Location
    Brooklyn, ny
    Posts
    69
    thank you, I'll try all suggestions.

Posting Permissions

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