hi yes i am checking the table does not have a persons details already. If the reply is null then i add the new person. thank to all for taking the time to helpBut the code does check that Forms!Newstaff!TxtDOB exists in the table or not, which is what the OP wanted. Probably the intent of the code is to check if a person has already been added to the table.
As to the error message, I wonder what sort of variable DOB is.