Hi thereThank goodness its Friday eh?I have a form witha field in it that indexed called UnitNumber, allowing no duplicates. I was wondering how to add a validation message telling the user that the 'unit number already exists' etc if they try and enter the same numberNot the best with VBA so be gentle