setting a recordsource multiple times in the same form 1

[striker73]

I am trying to re-set my recordset by using the Me.Recordsource = "SELECT * FROM MyTable" command multiple times in the code of my form. The second time the compiler gets to this like I get the error message saying I am referring to an object that is closed or doesn't exist. I don't recall running into this problem earlier. Any ideas on what's going on?

 

[KellyK]

Do you ever get to the end of your recordset? I think you need to reopen the recordset before each iteration. Before your Me.Recordset = "SELECT * FROM MYTABLE" I think you need Set Recordset = CurrentDb.OpenRecordset("...&quot

I think what's happening is the recordset is closed (like the message says) and you need to reopen it before you set a value.

 

[striker73]

I think you're right. I had a "Docmd.Close" line in between the two select statements, I was intending the form to be closed and not the database. Thanks for your help!