Forums

This topic is locked

Validating a Form Field with Values in a Recordset

Posted 24 Oct 2003 04:15:03
1
has voted
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!.

Reply to this topic