I'm updating a database that was created in an older version.
In that database, I had created a recordset in order to perform some searching through a table, etc.
Before, I successfully used the pattern:
Dim dbs as Database
Dim rstX as Recordset
Set dbs = CurrentDb
Set rstX = dbs.OpenRecordset("tblDATA"
' do stuff
rstX.Close
etc.
This doesn't seem to work anymore. The help files are a bit confusing. Can someone give me an Access 2000 equivalent of the above? I'm having some trouble with the new object / method conventions.
Thank you.
In that database, I had created a recordset in order to perform some searching through a table, etc.
Before, I successfully used the pattern:
Dim dbs as Database
Dim rstX as Recordset
Set dbs = CurrentDb
Set rstX = dbs.OpenRecordset("tblDATA"
' do stuff
rstX.Close
etc.
This doesn't seem to work anymore. The help files are a bit confusing. Can someone give me an Access 2000 equivalent of the above? I'm having some trouble with the new object / method conventions.
Thank you.