Difficult to say exactly, but it won't be the form opening, but probably the SQL query is not optimized.
>How come my program goes from 45MB to 150 MB of memory when 1 new form is open.
>
>Is it that SQL query are too complicat4ed or too many scan...
>
>The system gets slow and we are not efficient.
>
>Any idea.
>
>Thanks
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer