Referencing ADO Connection

[Rocko411]

I have an ADO connection to my SQL server. I'm trying to figure out how to reference this connection in other parts of the program to run stored procedures, populate grids, etc. I'm pretty sure that this is possible, I just can't find a good example. Any help would be greatly appreciated.

[nullus]

just use the name of the object variable

Dim con As ADODB.Connection
Set con = New ADODB.Connection
 
con.Open "blah blah"
 
rst.Open "select blah blah...", con, adOpenStatic, adLockOptimistic