recordset movenext propety

[Arafat]

Hello,

I have a userform on excel that connects to ms access DB, i have developed the code to display,movenext and update records but i have an issue when i try to move to the next record with SQL query that filters records.

ex: SQLquery= select * from table1 where test1='unique' --- then i do rs.movenext but everytime i click on cmd button it shows only next record even if the query returned 4 records... can anyone point where i am making the mistake ? I have several textboxes on the userform that displays the field values from access.

 

[xenou]

rs.movenext but everytime i click on cmd button it shows only next record even if the query returned 4 records...

movenext shows the next record. To see all four records you must movenext again, then again.

 

[Arafat]

Hi Xenou,

Thank you for your reply, i have resolved this issue.

Solution:

I made recordset and connection as global variables and used them to manipulate records and this way i was able to navigate without any glitch. It was a good learning.