Hi,

I have 10 forms and on EACH form I have done

dim cn as new adodn.connection

Form Load event

If cn.State <> 1 Then
cn.Open "Provider=SQLOLEDB.1;User ID=administrator;Initial Catalog=Meridian;Data Source=administrator"
End If
cn.CursorLocation = adUseClient


On each of the forms I have written the connection open string

Is there a way where I can write it only once and it works
for all forms ????

If yes where n how ?

Pls advice

thnks