VB Code:
  1. Found = False
  2.     If Dir(App.Path & "\Versions.mdb") <> "" Then
  3.         Set dbVersions = OpenDatabase(App.Path & "\Versions.mdb")
  4.     Else
  5.         Set dbVersions = CreateDatabase(App.Path & "\Versions.mdb", dbLangGeneral)
  6.     End If
  7.     For Each tblVersions In dbVersions.TableDefs 'This bit here
  8.         If tblVersions.Attributes = 0 And tblVersions.Name = "Stock" Then
  9.             Found = True
  10.             Exit For
  11.         End If
  12.     Next 'Too here
  13.     If Not Found Then Create.StockDatabase

Couldn't I just do this

VB Code:
  1. If Dir(App.Path & "\Versions.mdb") <> "" Then
  2.         Set dbVersions = OpenDatabase(App.Path & "\Versions.mdb")
  3.     Else
  4.         Set dbVersions = CreateDatabase(App.Path & "\Versions.mdb", dbLangGeneral)
  5. Create.stockdatabase
  6.     End If