How do you filter a report based on a value in a text box

Hi Joanne,

Thank you for your question.

I believe the only way to do it would be through Access VBA. I have tried various properties of the report and the text box itself.

You could try and create the calculated field in a query and then name and save the query.

Create a query based on that query and add all the fields and add a parameter to the calculated field.

Name and save the second query and create a report based on the second query.

When you view the report it should ask you for a value.

I hope this helps.

Regards

Simon