I have a form that I would like the user to search for records based on any field. It gets trickier. I actually have 3 forms that the user can flip between to search for records based on any field of any form. I tried using the qbf.scx (query-by-form) that is in the samples directory, but it seemed to have its limitations. Parameterized views do exactly what I want, but I'm running into this SQL statement too long problem. I'll be working on it today if you have any suggestions.

Thanks.