RT error 2176 "The setting for this property is too long."

[Euler271]

I'm using a search form that returns names of people who are attached to a selected project. I'm getting error 2176 when the IN statement I'm using as a filter for the form exceeds a certain number of characters. I think the number is 2048 but I'm not sure. I need to be able to return thousands of people, potentially, which would require a string length of of several thousand. The IN statement contains the primary keys for the people associated with the selected project.



Any thoughts on how to get around this error? Thanks for the help.

[June7]

Use a 'temp' table (table is permanent but records are temporary). Save the record IDs to temp table. Join that table to data table to restrict records.

[Euler271]

That's a good idea. I'll try it. Thanks.