I decided to pass array and only concern is with large number records. I put a check for that in code, and if over 40000 will switch to temp tables.

Thank you for your suggestions and have a great day!



>>Tried to implement this option, however, I get file in use error and can not seem to overcome.
>
>If your gonna go the route of trying to open the cursor from the second form, just make the cursor a temporary table on the local disk, that way you can open it nonexclusively from either form.
>
>If it's not a parent / child form relationship though.. you'll have to track which form should clean up the table.