Yes I use that method quite a lot but in this particular instance I had wanted to keep the sessions separate.
What I would really love is to be able to do a select on tables in one session and have the result in another.
I guess its back to the drawing board with exactly how these two forms hang together.
Thanks for the input.
Caroline
>Instead of passing the DBF() to the other form or session, you could pass the DataSessionID, change to that DataSession, then change back when finished.
>
>>Thanks for confirming this.
>>Unfortunately I can't do this as a number of process are performed to the cursor.
>>I think I will have to rethink my structure slightly.
>>
>>>Not the same cursor because they are created in exclusive use. You would have to pass the SQL used to create the cursor instead of the DBF() name. Then create another cursor using that same SQL.
Caroline