Visual data objects(in DAO)

hi! here is my question:

I specified a new sql query for the "recordsource" property, like this:
(dbtbillsdet is the data object!!)

"gsSql = "Select * From tBillsDet Where iBillRecID = " & DbtBills.Recordset!iBillRecID

DbtBillsDet.RecordSource = gsSql"

and then I used the refresh method:
DbtBillsDet.Refresh

i use it to show dynamic values in a grid according to a specific record id.

so my questions are:
1.is it crucial to close the data object(DbtBillsDet) before populating it with new data?
2.do i need to close all the data objects(i mean visual objects) when i close the forum(with DbtBillsDet.Recordset.Close and Set DbtBillsDets.Recordset = Nothing)?or are they freed automaticly from memory when the forum is closed?
thanks

What flavor of VB?

I haven't used DAO in years myself, but I suppose the same basic rules about destroying objects and cleanup in your code would apply. You may not "need" to destroy objects in code, but imho it's a good habit to do so.

thanks