Query by Form-TJ

[ambushsinger]

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]

On Mon, 31 May 2010 07:08:01 -0700, ambushsinger

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

 

[ryguy7272]

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?

 

[ambushsinger]

Thanks a lot. My way was making me crazy.

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?