It turned out that there was some garbage or something in the report as I knew about the table.field thing. I thought I had recreated the report, but when I actually did recreate it solved the problem. Thank you for responding.

>Terry,
>
>Do your report controls reference the table name? (MyTable.Field1) If they only reference the fieldname (Field1), you can run the report from whatever table is selected, as long as it has the necessary fields, and you don't need any tables in the data environment.
>
>>Right before running report form x preview, I have select y, locate. Then upon running the report the Open Table dialog open requesting the y table. If I put y in the dataenvironment of the report the report runs fine. I never have this problem, but with this form and report I cannot get around it. I have recreated the report with the wizard and recreated a new form also, but with the same results.
>>TIA