I know that by using public key word I can Declare a Public Variable which can be accessed from any form or module but what i want is........

C I have a MDI Form,4 child form and A Module In My Project I have the connectivity with Access.In each and every form I want that connectivity.So One way to do this is to write code for connectivity in each form.But I dont want to do that. What I want is.......
I want to make connection with access just once in a module (using Function)
and when the MDI form is loaded the connecitivity should be done. For that I have written the following code in module

private function Con()
dim con as new ADODB.connection
dim rs as new ADODB.recordset

con.open "<string for mdb>"
rs.open "<table>"

the problem is....
in child form or in MDI form i am not able to access this variables.This variables are shown with null values. If i Use public keyword instead of dim while declaration it gives me an error like "statement out of function " or something like this.

can anyone help me to access this con and rs variables in each Form.

Is there any way to do this?