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.
 
Back
Top