>>One more question if I may. I am calling both of these in the Data Enviornment Load Tables event. If I don't I get errors because the control source for the text boxes, etc. do not exist. Calling the prgs from there has me a bit worried although it seems to work ok so far. Any thoughts?
>
>You can do it in form's .load(), though then any objects of the form you may need are still not instantiated. As a legal workaround, you can do it in form's .init(), you only have to design the form with .BindControls=.f., and then in .init(), when you're done with opening tables, creating cursors etc, set it to .t. (too bad it's made to work only once - there are times when unbinding controls on a flip of a switch would be cool ;).
Blast it, I forgot about .BindControls=.f. I'll move them back to the init where they were before the crash.
We have a way of unbinding the controls. We added a property to all data object classes that holds the source. After the form loads we call a prg that then copies the source to the ControlSource. That prg can also clear the contolsource of all objects based on a flag in another property common to all classes. Doing this allows us to do some interesting things when the user is searching for data.
Thanks again.
Beer is proof that God loves man, and wants him to be happy. - Benjamin Franklin
John J. Henn