query parameters

[Paul]

What I'm looking to do is have a pull-down menu to select
the parameters for a query. So instead of having a dialog
box pop-up in which the user enters the department they
are looking for, a pull-down menu will pop up instead and
they can select their department. TIA!!

 

[[MVP] S. Clark]

You will need to build your own form to do so.

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-