Sometimes you may want to provide feedback to users to let them know how many records will be effected by some code. If you've previously used the RecordCount property to do this with a recordset, you may have received unexpected results. That's because it won't return the correct number until the last record in the recordset has been accessed. To force the RecordCount property to return the correct number of undeleted records, use the MoveLast method first. Keep in mind that this may cause a  performance hit on your application, so make sure it's necessary to work with the accurate record count before changing your code.

Access Index

Main Index