Hi All:
Pleae Help!!!!
I declared two variables at the module level. For example:
Dim oDataConn As ADODB.Connection
Dim oRecSet As ADODB.Recordset

Than I created a private procedure on my form (Getata).
In Getdata function I established my connection and recordset,however when my code leaves the Getdata function, my variable that I declared at the module level are also set to blank. Thus, how can I declare a public variable that would allow me to keep my recordset values.

Thanks
MA