Hi Experts –
I need some help check for duplicates from a form. I want to check and see if my customer is entering a duplicate number in the form and prompt them that they shouldn’t be. I have some code but it’s not working as expected.
You can grab a number from the CLAIMNBR field
on the form via copy and paste. Select new record from the record selector paste that number in the CLAIMNBR field
tab off the field and a message box should come up tells you it’s a duplicate in the table.
I have code behind the form behind the txtClaimNbr
textbox on the BeforeUpdate
That’s how I would like it to work.
As always any help is appreciated.
***** see example database *****
Thanks in advance,