A real strange problem. I have a screen form where I have the use select some options for producing a report. I then select a subset of the main data table based on the user input. I then total some numeric fields to a table. Depending on report options either the subset of data or the totalled table is used for prodcuing the report.
I then give the users the option to rerun the report with different option. I close the table of subset data and the totalled table and here is where the problem occurs. I get a 'File Not Open' error after the tables are closed.
I get the error message whether I use CLOSE DATA or select each table and issue a use. The strange thing also is that if I close the table individually, when I close the SECOND table, that is when I get the error.
ie
use disp
select *** fron disp to table curcost
total on emp to rpt15
report form ....
** then eitehr
CLOSE DATA
**or
SELECT curcost
use
select rpt15
use
** BOOM - 'Error File not open.'
HELP!!! PLEASE
Fred Lauckner
You know, it works on my computer. I don't know what your problem is.
.Net aint so bad.