>I was able to pull data from SQL View thru SQLEXEC() but I don't know the right approach to use or add them to my DataEnvironment programmatically as my datasource.
>
>thanks in advance
You can't. Add the code to draw the data down in the Load of the form. Load fires before any controls initialize so any control you have configured with the view as a ControlSource will work.
HTH.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao