I'm glad you got it working! I know the feeling when even a small annoyance can turn into hours of recoding.... yuck! You'll be a lot happier with VFP8 and its new features too...

>Thanks again hun, you rock!!! I got VFP8 today and went right into it and coded out the control source on the template table and used a direct use of a table outside the data environment and it didn't blow the whole thing out. This is gonna save me a whole lot of time from re-coding and is going to make everything run so much more efficiently. Thanks so much for taking the time to test that for me and verify the bug was fixed in version 8. What I am wondering is why it took microsoft that long to make something important like that work properly. That bug was very annoying.
>
>
>>Hi Kevin,
>>
>>This does not happen when I create the form and run it in VFP8. In fact, I created the form and put a table in the dataenvironment and threw a grid for it on the form. Then I loaded a 2nd table in the form's load event and threw a grid for it on the form. It all works fine. I then saved the form as a class (form classes do not have a dataenvironment as Chuck so kindly pointed out in this thread) and of course the table that was loaded in the dataenvironment on the form no longer exists for the form's use. That is when it blew. That is where my code I posted in this thread came from. I opened the class and copied the code and posted it here. It works fine when you do the same thing using just the form (no class) in VFP8 and call the form with DO FORM but since the form class has no dataenvironment, that part blows up when you create the form in code using CREATEOBJECT().
>>
>>Tracy
>>
>>
>>
>>>>No, duh,,,, what was I thinking???? :o) It's obviously not in the code either! good catch...
>>>>
>>>>>>This is very interesting. I first tested it by creating a form and loading a table in the form's load event and then loading a 2nd table in the form's data environment. I ran the form and it worked fine. Both tables were available on the grids.
>>>>>
>>>>>
>>>>>Sorry for jumping in but I didn't think form classes have dataenvironments, unless that's something new in VFP8.
>>>
>>>
>>>_____________________________________________________________
>>>
>>>Yes, this is true, but you would not need to create a class to easily test what I am talking about. Create a simple form, put an existing free table of any kind in the dataenvironment, then in the form load or init use another table and select it, then put in some code to reference something in on the table in the dataenivronment and it will let you know it was blown out because it will display an error. Of course I am still running VFP 7 and I am not sure if this was fixed in VFP 8...