I have run in a bit of a problem because of this
Dim DB As Database
Dim rs As Recordset
Dim Apps As FileSystemObject
Set Apps = CreateObject("Scripting.FileSystemObject")
'set db location
Set DB = OpenDatabase(App.Path & "\configuration.mdb")
'Open the Contact table
Set rs = DB.OpenRecordset("SELECT netVESPAWeb.*, ISDefine.SetPreProccessor, altCarriers.Carrier FROM (ISDefine INNER JOIN netVESPAWeb ON ISDefine.ID = netVESPAWeb.ISPreProccessorType) INNER JOIN altCarriers ON netVESPAWeb.SetCarriers = altCarriers.ID", dbOpenDynaset)

I cannot decalre this globally, or can i any help please, i'm using mutiple functions that follow the record set and need them globally visible..?

Thanks in advance