I am having a problem geting data from my tables in Access 2000.
I am using the rs.getstring() which returns all rows which is fine. After playing abit I started to use rs.getstring(,data.rsRADetail.AbsolutePosition,"|")
which returned the first line but then when I called this again to get the second row, I got 2nd and 3rd row and called it again and got 4th and 5th ??? why does this happen ? why did I not get the 1st and 2nd the first time a Called this command ?
I have called debug.print data.rsRADetail.AbsolutePosition and it shows 1 then 2 then 4. Can any one help me ??
I can post my code if needed.