changing the value of a recordset's property
-
Hi, I'm trying to change the value of a recordset's property. The property is "scroll backwards" (want to change from false to true). I opened a recordset, and then I got it's properties. I got the wanted property(according to it's index), but I can't change the value - I get an error saying that "the operation can't be done when the object is open". Which object is the error talking about? Do I need to change the property after openning the recordset? What am I doing wrong? Can someone please send me a code example of what should I do...??? Thanks.
-
Hi, I'm trying to change the value of a recordset's property. The property is "scroll backwards" (want to change from false to true). I opened a recordset, and then I got it's properties. I got the wanted property(according to it's index), but I can't change the value - I get an error saying that "the operation can't be done when the object is open". Which object is the error talking about? Do I need to change the property after openning the recordset? What am I doing wrong? Can someone please send me a code example of what should I do...??? Thanks.
Take a look at your CursorType if is forward only it might be the source of your problem.