A have an Access form and have connected it to an sql server table using ADODB by setting the form's recordset property to the ADO recordset. The first record comes up fine, but when I navigate to the next record, my ADO recordset property goes to a state of 0. While the form displays the next record in the set, the form's OnCurrent event won't fire.
What is closing my recordset? I'm not doing any requering or anything?