Hi Kirt. Would one be able to setup in the table that the field cannot be empty and thus avoid the need of the macro? Or what would the differences be? Thanks!