In this database, in the form "Child Information" I wrote SQL code to add all the data in the unbound fields into the table. In particular I am concerned about ensuring that birth date information is entered in a single format (MDY). When I press the button which runs the VBA code, I get the message "The changes you requested ... were not successful because they would create duplicate values..." But as far as I can tell, none of the data I have entered is actually duplicate. Is there something wrong with the SQL I used? Or is the database not structured well?