I have a form that has 1 field. The user enters information (text data), into the field. Then on the same form is a command button labeled "Add Info". When the command button is clicked I want to add a record to each of 8 tables. Each table has an auto-number field and a field named "Client".
How can I add a new record to each table and have the information entered in the form field to be added to the field, "Client" in each of the tables via VBA code only if the information entered is different than any other record's Client field. If the data already exists then have a message appear letting the user know that the record already exists.