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

Ask a Question

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.