I have a database where I have only one table. I have created a main form with 2 subforms. What I have done is to specify the criteria in the main form to open one of the subforms and hide the other one, but this creates duplicates in the table. Does anyone know why this happens and what can I do about it?

Geir Arne