I would like to build a form that contains a drop-down list of choices
pulled from a table called tblCategories, that, when a user chooses one of
the categories, that value gets passed on to a query which runs a search on
records that match that chosen category.

Is it possible to alter the parameter query dialog box to include a
drop-down menu, or create a separate form that will pass the value from the
drop-down menu to the query?

Thanks in advance...

sc

This is a multi-part message in MIME format.

------=_NextPart_000_003C_01C1CE7E.CFE6DFE0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit

Shelley,

Go to http://groups.yahoo.com/group/ms_access/files and download the
FilterRecords.mdb (for Access2K and AccessXP) or FilterRecords_97.mdb
(for Access97).

This question is asked a lot so I created a small db that shows you how
to display records in a form that meet criteria from a dropdown list.
You will be able to take the data and modify it to your specific needs.



John Ruff - The Eternal Optimist J

Always looking for Contract Opportunities

 

9306 Farwest Dr SW

Lakewood, WA 98498

papparuff@c...



-----Original Message-----
From: Shelley Curnow [mailto:SCurnow@h...]
Sent: Monday, March 18, 2002 12:52 PM
To: Access
Subject: [access] Passing a chosen value to a parameter query


I would like to build a form that contains a drop-down list of choices
pulled from a table called tblCategories, that, when a user chooses one
of the categories, that value gets passed on to a query which runs a
search on records that match that chosen category.

Is it possible to alter the parameter query dialog box to include a
drop-down menu, or create a separate form that will pass the value from
the drop-down menu to the query?

Thanks in advance...

sc