Query by Form-TJ

Discussion in 'Access VBA Modules' started by ambushsinger, May 31, 2010.

  1. ambushsinger

    ambushsinger Guest

    I need to do a Query by Form based on multiple selections from combo boxes on
    a form using Access 2000 I need to bring back the appropriate records in a
    subform.
     
    ambushsinger, May 31, 2010
    #1
    1. Advertisements

  2. On Mon, 31 May 2010 07:08:01 -0700, ambushsinger
    <> wrote:

    Query by Form can't do that. It can only select records in the current
    form view. After that, you can potentially open a new form with that
    subset of records in a subform.

    -Tom.
    Microsoft Access MVP


    >I need to do a Query by Form based on multiple selections from combo boxes on
    >a form using Access 2000 I need to bring back the appropriate records in a
    >subform.
     
    Tom van Stiphout, Jun 1, 2010
    #2
    1. Advertisements

  3. ambushsinger

    ryguy7272 Guest

    Hey Ambush! You may have to change your design a bit. Look here for some
    ideas on passing values from a ComboBox:
    http://www.fontstuff.com/access/acctut17.htm

    At the bottom of this page you can download a working sample called
    'AccessAndSQL4_2000.zip':
    http://www.fontstuff.com/access/acctut17a.htm

    Does that get you pretty close?

    --
    Ryan---
    If this information was helpful, please indicate this by clicking ''Yes''.


    "Tom van Stiphout" wrote:

    > On Mon, 31 May 2010 07:08:01 -0700, ambushsinger
    > <> wrote:
    >
    > Query by Form can't do that. It can only select records in the current
    > form view. After that, you can potentially open a new form with that
    > subset of records in a subform.
    >
    > -Tom.
    > Microsoft Access MVP
    >
    >
    > >I need to do a Query by Form based on multiple selections from combo boxes on
    > >a form using Access 2000 I need to bring back the appropriate records in a
    > >subform.

    > .
    >
     
    ryguy7272, Jun 1, 2010
    #3
  4. ambushsinger

    ambushsinger Guest

    Thanks a lot. My way was making me crazy.

    "ryguy7272" wrote:

    > Hey Ambush! You may have to change your design a bit. Look here for some
    > ideas on passing values from a ComboBox:
    > http://www.fontstuff.com/access/acctut17.htm
    >
    > At the bottom of this page you can download a working sample called
    > 'AccessAndSQL4_2000.zip':
    > http://www.fontstuff.com/access/acctut17a.htm
    >
    > Does that get you pretty close?
    >
    > --
    > Ryan---
    > If this information was helpful, please indicate this by clicking ''Yes''.
    >
    >
    > "Tom van Stiphout" wrote:
    >
    > > On Mon, 31 May 2010 07:08:01 -0700, ambushsinger
    > > <> wrote:
    > >
    > > Query by Form can't do that. It can only select records in the current
    > > form view. After that, you can potentially open a new form with that
    > > subset of records in a subform.
    > >
    > > -Tom.
    > > Microsoft Access MVP
    > >
    > >
    > > >I need to do a Query by Form based on multiple selections from combo boxes on
    > > >a form using Access 2000 I need to bring back the appropriate records in a
    > > >subform.

    > > .
    > >
     
    ambushsinger, Jun 2, 2010
    #4
    1. Advertisements

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. Paul

    Run a query based to another query

    Paul, Oct 12, 2003, in forum: Access VBA Modules
    Replies:
    9
    Views:
    134
    Dirk Goldgar
    Oct 15, 2003
  2. jn

    main form to sub form to another sub form

    jn, Feb 9, 2004, in forum: Access VBA Modules
    Replies:
    0
    Views:
    162
  3. Francisco

    Query based on another Query in VBA

    Francisco, May 27, 2004, in forum: Access VBA Modules
    Replies:
    2
    Views:
    100
    Francisco
    Jun 1, 2004
  4. James Stephens

    Incorporte Query into VBA or Pass VBA Value to Query

    James Stephens, Nov 11, 2004, in forum: Access VBA Modules
    Replies:
    5
    Views:
    182
    James Stephens
    Nov 12, 2004
  5. notDave

    If query results exist, export query, else don't?

    notDave, Dec 9, 2004, in forum: Access VBA Modules
    Replies:
    5
    Views:
    92
    John Vinson
    Dec 9, 2004
  6. Replies:
    0
    Views:
    114
  7. WatEva

    Query in VB/Passing it to a form/query

    WatEva, Sep 26, 2008, in forum: Access VBA Modules
    Replies:
    1
    Views:
    101
    OssieMac
    Sep 28, 2008
  8. GoBrowns!
    Replies:
    2
    Views:
    120
    GoBrowns!
    Jun 25, 2009
Loading...