>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

This code should not close down any cursors. The second cursor will be the selected one, however.