Forums
This topic is locked
Validating a Form Field with Values in a Recordset
24 Oct 2003 04:15:03 Al Patel posted:
I have a basic form that allows users to enter a record. The user can enter multiple records on this table, but the 'Title' field must be unique.How do I validate while the user is entering a Title, that they haven't entered that exact Title before?
If they enter a Title that matches, I'd like to abort the insert statement and have a popup message that lets them know they need to change the Title.
Thanks in Advance.
Huh?
Replies
Replied 24 Oct 2003 06:28:42
24 Oct 2003 06:28:42 asp1 asp1 replied:
maybe this might be something to look at. in the server behaviours there is a user authentication section, in there there is a "check new user name" this will check any field you choose and see if it exist if yes then it will redirect the user to a page that tell them it is taken, im sure you can change itto your needs!.