Recent content by clh42
-
C
Prevent duplicates, but not when editing existing record
Right, but as I've also already said, at least in this particular case, the fields I want to prevent duplicates of are already a compound primary key. But it still keeps me from having to add yet another separate autonumber field. I just hadn't thought of using the OnError event to trap the... -
C
Prevent duplicates, but not when editing existing record
I stated in my original post that it did not have such a field. As I said, from an actual data standpoint, I don't need one for any other purpose so I was trying to avoid adding one and taking up unnecessary storage space just for the purpose of the duplicate message handling for the form, if... -
C
Prevent duplicates, but not when editing existing record
Back to my original thought from my very first post, I take it at this point (since no one has given any info on such a thing) that there is NOT some sort of inherent record position within a table that could be used to check against the same way I might check against an explicit 3rd autonumber... -
C
Prevent duplicates, but not when editing existing record
Thank you both for your responses, but I have some follow up. To summarize, my ultimate goal is to provide a custom error message for a duplicate entry, but not only for entry of new records, but also when editing existing records. I apologize for being a long post, but I was afraid someone... -
C
Prevent duplicates, but not when editing existing record
I know the question of preventing duplicates has been asked many times before and I've found tons of messages here and elsewhere all giving the same answers, but I've not been able to find anyone else asking this specific variant of the question and I've found no answers. I had figured out how...