Hi,
I'm finally getting this database programming thing under control for the most part (enough to get dangerous ), but I have a queston concerning the above subject line.

When I open a recordset, set a datagrid.datasource to the recordset, and then set the recordset = nothing, everything is cool.

Now if I do the same thing as above, but close the recordset using rs.close before setting it to nothing, then the recordsource is not seen in the datagrid.

I guess what I'm wondering is, what is the real purpose of the .Close property or method. When should you use .Close

I know the Set rs = Nothing is to take it out of memory. But it is still avaiable to my datagrid. I'm really confused.

Clear as mud right?

Sorry for all of these dumb questions. I'm learning more and more every day.

Thanks,
JazzBass