Record set always available
Posted on 2000-03-08
I would like to create a record set and have it available throughout a module. I currently have the following lines:
rs_VendorData.CursorLocation = adUseClient
rs_VendorData.Open VendorDataSQLquery, ConnectionString, adOpenDynamic
My query and connectstring are defined at the top of my code on formload.
This code currently resides in the function I am calling so it is run every time (some 2000 times) when I place it in the calling procedure it is available the first time I call the function, once the function returns, the watchwindow will show all the elements in my recordset as out of context.
How does one set a recordset tyo be available for the "life" of a module.