Is an SQL statement limited to 256 char or something b/c when I try to add another control as a query’s criteria source I get a message that “The string returned by the builder is too long. The result will be truncated.”

There are certain places where you might build an SQL string in code that are limited. Use the query builder instead and create a stored querydef.

I designed a report & its recordsource is a query, criteria for the query is set to controls on a form which runs the report. I can’t enter all the criteria I’d like to b/c of the error message I previously mentioned in my first post.