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