Your question doesn't include any table structure, so it's very vague, but nevertheless much bettar than many previous ones, so I'm seeing this as progress nevertheless.
You need to open the report with the criteria you have determined. See the Help page for parameters for
DoCmd.OpenReport() and how to call it so as to filter the report.
Formulating a string to pass as the
WhereCriteria parameter is where the complication lies. You may need to be more specific with your question, as what you have isn't too clear. If you have a single field that you want to check for these exact values, then you will need to formulate a string that ends up something like :
- [FieldName] In('Eric','Arial','Mark')
How you design a form to allow you to do that might be a little fiddly.
If you need these matches to use wildcards at all, then this approach will not work. Instead, you will need to formulate a string like :
- ([FieldName] Like 'Eric*') OR ([FieldName] Like 'Arial*') OR ([FieldName] Like 'Mark*')
For more on filtering and building up workable criteria strings see
Example Filtering on a Form.
180
