Duplicate Records from multiple data-entry forms

[Guest]

My table is indexed to prevent duplicate entries for the primary key. I have
two data-entry forms bound to this same table. Neither form will allow a
duplicate record entry, but I can add the same record in each form and end up
with duplicate entries in the table. How can I get Form2 to reject a record
already entered in Form1? (Form1 is closed when Form2 is open and vise
versa.)

Thank you-- Linda

 

[doodle]

if you have the primary key set to not allow dups, it should work, but
you could use DCount to check the table

-doodle

 

[Douglas J. Steele]

The forms don't accept or reject the data: the table itself does.

 

[Guest]

Any idea why the table would reject a record entered twice via the same form
but not if entered separately via different forms? Thanks for any input.
Linda