Hi,

>>
I need to know if there's a way to get a collection of all tables opened within the data environment of a form. The tables are opened using code (use tablename share ) and not via the GUI in the Data environment.
>>

If you are opening the tables with 'USE..' they will not be in the dataenvironment - to do that you would need to add them programatically before the DE.OpenTables() occurs. For tables that ARE in the DE something like :

FOR EACH o IN thisform.dataenvironment.objects
  IF o.baseclass = "Cursor"
    ? o.name,o.alias,o.Cursorsource  &&etc.
  ENDIF
ENDFOR

HTH,
Viv