>Jen,
>I've occasionally had this problem, and it's always been caused by 'developer error'. Usually I've renamed a table, changed a view, moved a table or in some manner kept one or more tables from being found. You can prevent it by choosing 'cancel' with the first message and then looking carefully at your data environment. Open the form as a table and look at the information stored in the 'cursor' classes.
>
>>I created a form with a data environment that has 7 tables added to it with relationships. When I run the form to test it I get the following error - "Alias 'CC1BIL' is not found. Unbinding object txtbillnum". It then proceeds to unbind all bound controls on the form. When I go back to the data environment, all my tables "disappeared". This has happened several times with this form. I cannot pin point what causes the tables to disappear, it doesn't happen every time I run the form. Why are my tables disappearing from my Data Environment? - Jen
I've had that recently, and first time I recreated my DE it deleted it several edit/run cycles later. After that I don't run the form from the designer anymore - exit, and then run.
I've heard that when this happens first time, the DE records in the form may still be there, just deleted. USE the.scx, Set Dele Off and browse - may give you a chance to recover. If another edit/save is done before recalling these records, the .scx gets packed and we get a good chance to create DE from scratch :).
Happened to me only twice, and both times to the same form, same hour. Didn't run it from the designer anymore, and the DE's still there (I'll check tomorrow, though :).