Hi all - Happy Friday.
I know how to filter for a single value
Now for the harder question. I went looking around Google but no joy.Code:xyz.form.Filter = "FindMyResult" xyz.form.FilterOn = True
I have a query that returns multiple results, all of which I would like to be included in the filter (not just one value. All the results will be in the first table
I thought xyz.form.Filter = "Select * from TblMyTable WHERE [Field1] LIKE '*" & strSearch & "*'" might work. It doesn't.
I could easy replace the recordset, but I don't wanna, because I'd then have to change it back and mess about with all kinds of other stuff.
What's the quick n dirty way to filter a recordset based on query results?
Cheers and advance thanks for helpful response