Finally starting some coding in VB.Net
I notice over the years, that we can say (in VB6)

Code:
Dim MyForm_Stock as NEW frmStock
I have never really understood 100% what this does (other than create a form which can be used)

Could someone please explain how this helps me in terms of the same person, in the same session, being able to open, say 3 Stock Forms at the same time and maintain details independantly of each of the other forms

Also am I able to maintain separate Database connections and the same table being opened and updated independantly of each other by each separate form

What is actually taking place in terms of memory being used by each process ?

My ultimate goal is to be able to have ONE Module with all the possible data Connection and Recordset Opening and closing options, which I have failed miserably to do in my VB6 experience. Data access is an obvious module based set of subroutines. Others could be Date routines eg, Week Number of the year, Days Diff, Days to, etc. various other subroutines - any good ideas ?

eg, For Data
Make Database (Pass a string)
Make Table (Pass a string for name and Fields)
Open Database (Pass a string)
Open table (Pass a string or SQL Statement)

etc