using a filter on a report

[lubbs65]

So I have a report of names on a form and say list of parts they sold.
so it would say something like:

bob bike
joe car
sally ice cream
bob car
bob ice cream
etc...

rather than using filter, or right clicking there name and using "Equals: "name here""

My first idea was if there was a way to perhaps create a combo box on the report.

so you would select the name from a drop down and then every item involved with that person would then show. so, if i selected bob via combo box my report would look like:
bob bike
bob car
bob ice cream

Again though, I am trying to filter a report, not a form.
The form is based off of a query if that will make it any easier. Just because though, I can't simply select a name in the names column and hist "equals" nor can I click a name under the names column and then click "Filter" then check the appropriate names.

If you know of a method that doesn't involve a combo box it should be fine. but I feel like a combo box would be best.

 

[lubbs65]

also, for the method where you would use say 4 combo boxes (similiar to your method)
lets say you want to leave out order date. so you select a date range, company name, and employee but want to see all order dates how can you leave that field blank and have it still display all date ranges?