Drop down box in a Parameter Query

  • Thread starter Thread starter Frank
  • Start date Start date
F

Frank

Is there a way to have a drop down box inserted in the
prompt of a parameter query? I have a list of SSNs that
instead of typing the entire number out when prompt, I can
select it from a drop down menu. I am very limited to my
ability in VB, so please give me a detailed response.
Appreciate the help.

Frank
 
No, you can't do this in a standard parameter query. You will have to make
a form with a combo box and use that for your prompt. On my website, see
sig below, is a small sample database called "ParaQuerySelect.mdb" which
illustrates how.
 
Back
Top