Stop Fooling Database Entry Users

[Mark Entzminger]

I have a web form that allows users to enter information in a web
form. Two fields (username and email) are set in Access 2007 to
Index
(No Duplicates), however when testing the forms duplicate entries
are
not created in Access, however the website functions as if the
username and email were unique when in fact they are not.
My question is:

How do I

1. Verify the information entered into the form prior to clicking the
submit button

OR,

2. How can I tell front page to display an error message that
stating
the username or email is already in use?

I'm using FP 2003, Access 2007, Windows XP. Database forms were
created using the Database Interface Wizard (DIW)

 

[Mark Entzminger]

I have a web form that allows users to enter information in a web
form.  Two fields (username and email) are set in Access 2007 to
Index
(No Duplicates),  however when testing the forms duplicate entries
are
not created in Access, however the website functions as if the
username and email were unique when in fact they are not.
My question is:

How do I

1.  Verify the information entered into the form prior to clicking the
submit button

OR,

2.  How can I tell front page to display an error message that
stating
the username or email is already in use?

I'm using FP 2003, Access 2007, Windows XP.  Database forms were
created using the Database Interface Wizard (DIW)

SOLVED: http://support.microsoft.com/kb/314440

Now how do I customize the error page?