Global Variable Declaration In Module

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?

You actually answered your own question. Take con and rs out of the function, and declare them as Public variables in your module, then just use them in your function (which should also be Public).

if i declare con and rs outside the function vb gives me error like

"declaration is not allowed here"......

and if i declare them (function or variable) public then also an error message occurs
what should i do?

Quote:

---

Originally Posted by jalzaaal

if i declare con and rs outside the function vb gives me error like

"declaration is not allowed here"......

and if i declare them (function or variable) public then also an error message occurs
what should i do?

---

You need to declare them in the declarations section of the module. Where you are declaring them now?

at the very first line i have declared them

Attached is a sample module showing where, in the module, they should go.