Wed 10 Aug 2011, 16:06Delegate Joanne said...
Joanne has attended:
Access Intermediate course
How do you filter a report based on a value in a text box
As above
Fri 12 Aug 2011, 18:00Trainer Simon said...
RE: 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
