query requirements

  • Thread starter Thread starter caleb
  • Start date Start date
C

caleb

I put the criteria in the query for the artist, that
reads "[Enter Artist Name Here]" when i open a report or
anything that is based off of this query, a box pops up
where u have to type in something...is there anyway to
have a combo box open up instead?
 
There's no way to have a parameter prompt anything other than what you're
currently getting.

However, you can create a form that has the combobox on it, replace [Enter
Artist Name Here] with a reference to the name of the combobox in the format
Forms!NameOfForm!NameOfCombobox and then have a button on the form that
launches the query when the combobox has had something selected in it.
 

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

requirments 2
Problems with an ' in my data 3
Report not in right order 3
Report problem - main report and subreport 2
Parameter query using wildcard? Beginner level 2
Enter Parameter Box pops up even though its not in query 7
Combo Box Question 4
Criteria in Querry to include All and Empty Field 9

Back
Top