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.

On Mon, 31 May 2010 07:08:01 -0700, ambushsinger
<(E-Mail Removed)> 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.

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
> <(E-Mail Removed)> 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.
> .
>

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
> > <(E-Mail Removed)> 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.
> > .
> >