Filter report by user input?

[Kade]

I've generated a report based on a crosstab query.
It lists all of my records.

When I click on the report I would like a propmt for the user to input a field name (text) to filter the records of my report.

Essentially I would like my report to run like it would as a query with '[Input Whatever]' as the chosen fields criteria.

Filter the report by 'x name' via user input.

I hope this makes sense. My head is mush.

[ranman256]

user picks an item out of combo box on form
docmd.openreport "rMyXtabRpt",,"[field]=" & cboBox