Leaving DB open

  • Thread starter Thread starter dave h
  • Start date Start date
D

dave h

Hi,

If I assign a recordset to a listbox, the list box loses the data as soon as
the DB is closed. Two questions:

1. After retrieving data useing DAO recordsets to fill a list box, what are
the implications of not issueing a "myDB.Close"?
2. Is there a way to close the DB and still have the data remain in the
list box - using recordset versus rowsource and an SQL string?

Thanks Dave H.
 
The only way the Value List will persist is if the form is opened in design
view, set, and then saved.
I use SQL strings almost exclusively as Row Sources.
 
Thanks Duane, I think your advice about sticking with rowsources is the best
approach. I like to debug the sql using recordsets, so I thought it would
be a good idea to continue using them for assigning to list boxes (for
future debugging issues), but it is no big deal to comment out the recordset
stuff and use rowsource. Thanks, Dave H.
 
Back
Top