Thanks for that vbaInet. I think it should work. I implemented it, but before I could test it, the database has become corrupted :banghead:
Also, I've eliminated the chances of there being a blank record.
I'll need to fix the DB now. If you so happen to use Access 2010, could you be kind to...