requirments

  • 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?
 
Yes, but you have to put the combo box on a form and then pull the entry
from the form. The form must be opened when the query runs.

Rick B



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?
 
Only if you use a form.

You can refer to the value in the combo by putting something like this in
the Criteria row of your query:
[Forms].[Form1].[Combo1]
 
Back
Top