Two DAO.Recordset One CurrentDb

  • Thread starter Thread starter rebelscum0000
  • Start date Start date
R

rebelscum0000

Dear All,

Can someone please let me know if is correct to open two DAO.Recordset
and just one
CurrentDb like this:

Dim dbMyKeywordSe As Database
Dim rstMyKeywordSe As DAO.Recordset
Dim rstMyKeywordTaSt As DAO.Recordset

Set dbMyKeywordSe = CurrentDb
Set rstMyKeywordTaSt = dbMyKeywordSe.OpenRecordset(SQL1, dbOpenDynaset)
Set rstMyKeywordSe = dbMyKeywordSe.OpenRecordset(sQL2, dbOpenDynaset)

Is this the right way? Or I am lost?

Thanks in advance
Kind Regards,
Antonio Macias
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

CurrentDB() vs DbEngine(0)(0): Redeeming Qualities? 10
Determine number of records in table 4
Retrieving a value from a table 1
How to read the data in a tbl and save the records in a .txt file? 8
Opening a recordset in a function 3
Excel automation 2
update table via VBA 4
NotInList updated but not shown on form until close and reopen 12

Back
Top