requirments

[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?

 

[Rick B]

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?

 

[Allen Browne]

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]