Can not add a new record

[simba]

Please see the attached database. When I go to a new record, I cannot add a pediatrician or genetic center from the main form.



It warns that it would create a duplicate value

Any help on this highly appreciated.

[ajetrumpet]

i believe the reason is because you're creating a circular reference with the subforms on your main form because they have the same source as your main form.

[simba]

I would appreciate, if you can explain where I am using circular reference. To be honest, I do not know where I am making a mistake.

[ajetrumpet]

I would appreciate, if you can explain where I am using circular reference. To be honest, I do not know where I am making a mistake.

see the recordsource on your MAIN FORM:



Now see that your genetic subform on the second tab strip also has the same recordsource as what you see above:



All of your subforms are like this, and the only time you do NOT get the duplicate error message is when you click on the first tab strip, which is the only tab that does NOT contain a subform on it with the same recordsource as your main form.

[simba]

Thank you man for the detailed explanation. I am looking into how to change that.