I have a form with a sub-form. When a text field in the sub-form is double-clicked a new record is created in a table and the new record has 4 text fields. But if the same combination of the 4 text fields already exists in the table, I want the user to get a message letting them know this record already exists and not let the new record be created.
The 4 fields are txtCategory, txtSubCategory, txtJobNo, and txtDescription.
What would the VBA code look like?