jmccann
|
| Posted: 09/29/2002, 1:40 PM |
|
I'm building a subscription site where I want the user to input their own unique user name when they create a new record. I'm inserting this record using a unique Record ID. When a user enters a duplicate user name I would like to trap this and then display a metafile error message.
Can anyone advise how to do this? I’m using Access 2000
Many thanks in anticipation.
|
|
|
 |
Nicole
|
| Posted: 10/02/2002, 2:24 AM |
|
Hello,
just set Unique property for the user name field to TRUE and warning message will be displayed automatically before data is inserted in the table (of course there will be no insert if the value is not unique)
|
|
|
|
jmccann
|
| Posted: 10/02/2002, 2:16 PM |
|
Nicole,
Many thanks for this. Your reply now prompts a follow up...
How can I change the text of the displayed error message?
Thanks again in anticipation.
|
|
|
|
|
