I'm sure the answer is a carefully placed IF and ELSE statement to check the recordset to see if it has any results and to do something different when it doesn't. However this is too complex and custom for me to really give more than general direction for. This would be better suited for a premium support ticket.