I just spent the day creating a nifty page that writes a very long WHERE clause. I've tried to apply it to a form using:
Forms![MyForm].Filter = "ReallyLongFilter"
and using:
DoCmd.ApplyFilter , "ReallyLongFilter"
But I think Access is appending both attempts at around 256 chars...
Does anyone know how I can apply a long filter to my form?
Thanks,
Steve
Forms![MyForm].Filter = "ReallyLongFilter"
and using:
DoCmd.ApplyFilter , "ReallyLongFilter"
But I think Access is appending both attempts at around 256 chars...
Does anyone know how I can apply a long filter to my form?
Thanks,
Steve