I have a recordset and the textboxes in my form is bounded to that recordset.
I use this statement in my program:
"select * from collection where posted = 1 order by account_no"
It seems that if the recordset is executed with "ORDER BY" you can not move the record pointer backward. Is there a way I can order the recordset and at the same time i can do .moveprevious, .movenext?
Thanks in advance!!!!
I use this statement in my program:
"select * from collection where posted = 1 order by account_no"
It seems that if the recordset is executed with "ORDER BY" you can not move the record pointer backward. Is there a way I can order the recordset and at the same time i can do .moveprevious, .movenext?
Thanks in advance!!!!