Combox box in SQL code

R

red6000

Hi, I have a QUERY where my final line of code is:

WHERE ((([Individual Full Summary].CSRName)=[Enter name of CSR - must be
spelt correctly]))

Is it possible to amend this code so that the 'Enter Parameter' box that
appears is a combobox with the data held from 'CSRNames.CSRNames' table?

Many thanks.

Steve.
 
K

Ken Snell \(MVP\)

No. You would have to open a form that has a combo box on it and let that
combo box contain the allowed values, then have the query read the parameter
value froma that form (the form must be open when the query runs). The
query's clause then would be

WHERE ((([Individual Full
Summary].CSRName)=[Forms]![FormName]![ComboBoxName]
 

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

Top