MS Access Help

[Nate]

I have a report based on a dynamic query and it works but i have to type in the value. Is there a way that i could use a drop down.

For example lets say its cars and i want all the results for one type of car at the moment i click the report and it asks me which one and lets say i have to type in 'volvo'

Now or the type are stored in a table could i not use a dropdown that lists them all so i could just select one and click ok?

Could this be done on a form?

 

[Nate]

yes i know that i think the point has been slighty lost i need a form that i put information into that then runs a report that is based on a dynamic query which is where the information i put into the form is needed.