How to set Global Declaration, or how to set sub main as the startup form

[bizzy_e23]

Dim con As New OleDb.OleDbConnection
Dim ds As New DataSet
Dim adapt As New OleDb.OleDbDataAdapter
Dim sql As String

i want to declare the following in a module and set a sub main() in the module and call form1.show,

but i cant set the submain as the startup form.

[jmcilhinney]

Please use the radio buttons provided to specify your version in future.

I assume that you are using VB 2005 or VB 2008, in which case you would have to disable the Application Framework to use a Main method as your entry point. The preferred alternative is to use the Startup event to do whatever you would normally do in a Main method.

As for your plan to use a module for those variables, it could be forgiven, if not recommended, for the DataSet and OleDbConnection, but certainly not for the OleDbDataAdapter and the String.