You can add a module to your project and declare your variables as Public variables in the module. You can then use those variables in both your form and dialog form.

Here is the code to add shippers table to the test.mdb:


Dim appAccess As Object
Dim dbname As String, xmlFile As String
dbname = "C:\test.mdb"
xmlFile = "c:\shippers.xml"
...

Microtools.us also offers you a tool to convert Access forms and modules to VB6 applications.

You can take a look at the Microtools' Access to VB .NET/C# for Windows applications converters. Their url is <URL SNIPPED>