Unbind? Textboxes

[RollingMoose]

I'm probably not thinking this through.......but here's my question.

I have a form with an assortment of text boxes. I create an ADO recordset through code and bind the text boxes to the recordset with the datasource & datafield properties. What I need to do is refresh the form and recordset. In order to close and re-open the recordset, I assume I have to "unbind" the textboxes before I close the recordset...???
I can't open the recordset through executing a command because I need the ability to edit the recordset, so that isn't a possibility.

Thanks for any advice or suggestions.

 

[robctech]

have you tried using requery?

 

[RollingMoose]

Thanks, but I think that would require opening the recordset by executing a command if I'm not mistaken, which would make the recordset read only.....and I need the ability to edit.