Check for Duplicate Values Before Inserting Form

[jasons]

I have a form which inserts data into an Access table. The form contains field (MatchNumber) that denotes wrestling match for the tournament. The user will enter the match number and submit it with other match details.

How can I perform a check before the insert is complete that checks to make sure that the user hasn't already inserted a record for the same match number?

Thanks in advance for your advice.

[Newsgroup_User]

In the Standard Server Behaviours there is one called "Check Username".
Although it was intended as part of a login routine all it does is check for
the existance of a metching form and database value, so you will be able to
use it here.

--
Paul Whitham
Certified Dreamweaver MX2004 Professional
Adobe Community Expert - Dreamweaver

Valleybiz Internet Design
www.valleybiz.net

"jasons" <webforumsuser@macromedia.com> wrote in message
news:eo8jra$qpi$1@forums.macromedia.com...
>I have a form which inserts data into an Access table. The form contains
>field
> (MatchNumber) that denotes wrestling match for the tournament. The user
> will
> enter the match number and submit it with other match details.
>
> How can I perform a check before the insert is complete that checks to
> make
> sure that the user hasn't already inserted a record for the same match
> number?
>
> Thanks in advance for your advice.
>