F
faapa via AccessMonster.com
Hi
Is there a piece of code i can write on a form to check if duplicate data has
been entered?
Basically, i have a textbox on a form that requires the user to enter a title
(pm_title) i was hoping that if the user types in the same title, an error
will appear, alerting the user that the title can not be used as a previous
entry has that name so they have to create a new one....i hope that makes
sense!
(The PM table has an pm_id which is hidden and only pm_title can be seen by
the user.)
Would anyone know how to do this??
Is there a piece of code i can write on a form to check if duplicate data has
been entered?
Basically, i have a textbox on a form that requires the user to enter a title
(pm_title) i was hoping that if the user types in the same title, an error
will appear, alerting the user that the title can not be used as a previous
entry has that name so they have to create a new one....i hope that makes
sense!
(The PM table has an pm_id which is hidden and only pm_title can be seen by
the user.)
Would anyone know how to do this??