One of our tables/forms seems to be “spontaneously” copying records… It’s only about once a week & usu. w/the same 2 records. (It’s our “mail list” which consists of two tables – one used for general info on company, the other used in subform for contact info.)
The odd thing is that the record will be copied but with only a couple fields filled in (name of company & one other field).
Users are NOT (at least deliberately!) making copies.
This is aggravating bec. this particular info is used throughout the database as drop-down, etc.
Any ideas as to why this might be happening would be greatly appreciated.
Thank you!
Sherry