Hi Every:
I have two cursors that I want to use. I don't want to use table because it creates a problem of deleting the table after the form closes. The problem is that when I open the second cursor, it closes the first one. How can I open two cursors in two different areas. This will solve the problem where the second cursor close the first one. Here is my code:

***Code for first cursor
Select * ; && select the data into the cursor
From SqlResult ;
Where recno() < 20;
ORDER BY SqlResult.jobnum;
InTo Cursor cAcct && first cursor

***Code for second cursor
Select * ; && select the data into the cursor
From Jcjob;
ORDER BY jcjob.jobAcct;
InTo Cursor cJob && second cursor

What happens is that when the second cursor (cJob) is open, it closes the first cursor (cAcct). How can I keep them both open.

Thanks
MA