I am trying to write a macro for a command button on a "Master" form. The master form has 6 variables on it that act like one primary key. When I click the button, I want the second form's table to be searched to see if these 6 variables exist together in one record in the table. If all six of these don't exist together, I want to create a new record. I have tried writing a DLookUp statement for this, but it ends up being too long and it all won't fit. Can anyone help?