iv******@yahoo.com (nick_faye) wrote in message news:<8a*************************@posting.google.c om>...
why does my recordcount returns the # of actual records + 1? btw, i
am using ms access. i don't know what happened but at first, my table
seems ok. the recordcount returns the correct # of records. but as i
manipulate the table, (add, delete, etc) i get errors and when i
checked my recordcount, it returns 1 more than the actual # of
records. what did i do? how can i avoid this to happen again?
please help!
nick_faye
Guess how many fingers I'm holding up.
What kind of recordset? could we see the code? (Sorry, my crystal
ball is in the shop.) "btw, [you] are using Access."
Congratulations. You're in the right group. What's the difference
between "at first" and now? If you're opening a static recordset and
now refreshing the count, then there's your problem.