It errors on the first item because there is no previous item. You should check that you're not at BOF before calling the DoCmd and then shift to EOF if you are and want it to loop round or ignore the request (or msgbox) otherwise.
It errors on the first item because there is no previous item. You should check that you're not at BOF before calling the DoCmd and then shift to EOF if you are and want it to loop round or ignore the request (or msgbox) otherwise.