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
<ambushsinger@discussions.microsoft.com> 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
> <ambushsinger@discussions.microsoft.com> 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
> > <ambushsinger@discussions.microsoft.com> 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.
> > .
> >