The code looks good. I was hoping to avoid the "use" statement and that I could issue a "reload" or "requery" to the dataenvironment. The USE statement is not as fast as letting the dataenvironment open the tables itself.

>I don't know the syntax, but if there's some way to loop through the cursors, you could just USE each one.
>
>Maybe
>
>For i = 1 to de.controlcount
>x = "de.cursor"+allt(str(i))+".cursorsource"
>USE (x) in 0
>endfor
>
>No clue if that works. :) But maybe will get you down the right track?
>
>-Michelle
>
>
>>Hi Michelle.
>>
>>Actually. That is the part I knew. :-}
>>How do I then open all cursors in the DE?
>>
>>>Would setting AutoOpenTables to .F. work?
>>
>>>>I am moving the code that points my dataenvironment's cursors to the proper directory from the dataenvironments beforeopentables event to the forms (actually the class's) load event. The code is
>>>>
>>>>thisform.SetAll("Database",gcAppPath+"\database\patdb.dbc","Cursor")
>>>>
>>>>I am getting the error "property setting will not take effect until the data environment is loaded". I assume is is because the cursors are already open before the load event. How do I delay the opening opening of the cursors and then open them manually?