>Can anyone please give me guidance on what I need to do to make sure the new table data is reflected in the report.
>thisform.crxreport = thisform.crxapplication.openreport("C:\sales\stndbred\2000\strptravel.rpt")
James,
Given you that you need to access the data through ODBC, you can do the following, where
cODBCDataSource represents your VFP free-table DSN:
FOR EACH oTable IN THISFORM.crxReport.Database.Tables
oTable.SetLogonInfo(cODBCDataSource)
ENDFOR
Hope that helps.
Laterness,
Jon
Jon Rosenbaum
Devcon Drummer