global recordset?

[Onslaughtdave]

Hi,

Is creating a global recordset possible? If not can i run multiple recordsets on one table?

thanks,

dave

 

[cmmrfrds]

Yes and Yes.

 

[Onslaughtdave]

Well...that was easy

thanks

 

[Onslaughtdave]

umm...

how do you declare a global database and recordset...

 

[PHV]

In a standard code module, just after this lines:
Option Compare Database
Option Explicit
Add something likee this:
Public myDB As DAO.Database, myRS As DAO.Recordset

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244