check unique entry on update
have managed to get the check unique entry on insert working fine by using a recordset and checking if there is an existing value and validating against the recordcount.
now my problem is with the update, obviously as there exists a record (the one i am updating)
it returns 1 as the record count so wont validate.
so how do i check this on an update?