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 ?