help!!

in the module i did :

Public con As ADODB.Connection

now after i set in form1:

con.Execute x

he doesnt recognize it i think

what to do ?

I think all you will have to do is tell the form what module the connection is coming from.
Like this:

module1.con.execute x

I found this was happening to me before, and this solved my problem.

Hope this helps.