Im trying to prevent duplicate entry when entering data into a field in a form.
I want to know as soon as I enter the data that it is a duplicate.
I have found that I can do it by using a macro Refresh in the after update
The problem I now have is the standard response dialog boxes.
I am working with the North wind template and changing it.
Can I use code to do the refresh to check if it is a duplicate and the get the response for the dialog box from the string table.
I want to know as soon as I enter the data that it is a duplicate.
I have found that I can do it by using a macro Refresh in the after update
The problem I now have is the standard response dialog boxes.
I am working with the North wind template and changing it.
Can I use code to do the refresh to check if it is a duplicate and the get the response for the dialog box from the string table.