Connection function

[SeaHag]

How do i create a function to return a
Access table that i may read from somwhere
else in my project.

This is what i have so far... but I think its returning the
wrong thing... as well where would i use the .close ?

Public Function getRecordset(Table As String) As Recordset
Dim dbsBlastRoom As Database
 
 
Set dbsBlastRoom = OpenDatabase(App.Path & "\blstroom.mdb")
Set getRecordset = dbsBlastRoom.OpenRecordset(Table)
 
myRecordset.Close
dbsBlastRoom.Close
End Function
 
 
Seahag