I have a subform in which i need to filter, but the standard code:
Me.OLP_Search_SubForm.Form.Filter = strWhere
Me.OLP_Search_SubForm.Form.FilterOn = True
Throws an error due to the length of the where clause, that property seems to max out somewhere around 2000 characters. I thought to try...