help

[Emerican]

i keep trying to write the same damn thing and something is not working here...
in decl... i have
global db as database
global rc as recordset

right and in my code i have
set db = DBEngine.OpenDatabase("C:\somefile.mdb")
set rc = db.openrecordset("main")
' which is the table i want to look at

now i use the recordset once right... and then i try to access it again in another function and get an object error. object invalid or no longer set... now what does this mean?

Everytime you open a recordset for example:
*Database already declared
Public sql as string
Public rc as Recordset

sql = "SELECT * FROM Table WHERE ......."
set rc = mdb.openrecordset(sql)
With rc
********************
********************
End with

*Important
rc.close
Always remember to close your recordset especially when you
use a global recordset.

Joffies