Drop down box in a Parameter Query

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
 
R

Roger Carlson

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Paramater Query with drop down menu 5
Parameter Query with Drop-down Box 7
Query with drop down box 2
date parameter calendar drop down 1
Parameter value in Query 4
Drop Down List Prompt 1
Drop Down Properties 1
Query parameter 1

Top