Query Criteria Prompt Combo box

  • Thread starter Thread starter Christi
  • Start date Start date
C

Christi

Is there a way to change the "prompt box" for criteria
selection in one query to a combo box based on another
query. Basically when you open query A I want it to
prompt the user with a combo box in which they can select
the appropriate parameter based on query B so they don't
have to type in the criteria, but rather select it.
 
Not using a parameter query. You will need to create your own form with the
comboboxes.

--
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
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Is there a way to change the "prompt box" for criteria
selection in one query to a combo box based on another
query. Basically when you open query A I want it to
prompt the user with a combo box in which they can select
the appropriate parameter based on query B so they don't
have to type in the criteria, but rather select it.

Turn your logic around. Rather than having the Query open a form with
a combo box, have a Form which opens the Query.

Create a small unbound form, let's call it frmCrit. Put a combo box
(cboX) on it. In the criteria row of your query put

=[Forms]![frmCrit]![cboX]

You must open frmCrit FIRST (otherwise the query will just prompt you
for the value); it's convenient to put a command button on frmCrit to
open the Form or Report you're using to display the data. If you're
using a query datasheet to display the data... DON'T, users should
never see datasheets; but if you insist, a command button can do that
too.
 
Back
Top