I KEEP GET A ERROR MESSAGE run time error 94 invalid use of null

[MIkeD666]

But 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.

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 help