I have a recordset that says Recordcount is 7, but when I tell it to MoveLast, it goes to 6. If it's on 6 and I tell it to MoveNext, it goes into EOF and gives errors.
The code is too long to post here, but I did a search and saw some comments about problems with nested loops. This makes sense because it only gives the error when I call other loops and recordsets outside the function. But I don't know a way around that. I'm actually working on the same data in a few different recordsets, but I'm not sure why that would cause a problem if they're all separately defined (I also tried using the same recordset multiple times). And either way, when I say MoveLast, it seems that it should know that if there are 7 records, then it goes to the last one.
Any ideas?
The code is too long to post here, but I did a search and saw some comments about problems with nested loops. This makes sense because it only gives the error when I call other loops and recordsets outside the function. But I don't know a way around that. I'm actually working on the same data in a few different recordsets, but I'm not sure why that would cause a problem if they're all separately defined (I also tried using the same recordset multiple times). And either way, when I say MoveLast, it seems that it should know that if there are 7 records, then it goes to the last one.
Any ideas?