Use the .recordcount property. Also, be aware that if you're using DAO rather than ADO, you'll have to .movefrist .movelast in order to get an accurate count (old DAO bug, but if you're only workgrouping or running local, it's less overhead than an ADO connection).