Duplicate Records from multiple data-entry forms

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
if you have the primary key set to not allow dups, it should work, but
you could use DCount to check the table

-doodle
 
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
 
Back
Top