Re: Preventing Duplicates in BeforePost event.


>This worked great while the user was entering the values. However, if at a
>later time in the code a record had to be modified, the BeforePost event
>would fire and then I would get the message about a dupicate record. This
>is because the cloned dataset now had all entered record and whenever the
>BeforePost event fires it aready has the values.
You should be able to check the STATUS property. If it is dsInsert use your
code and if it is DSUpdate you need to check for more than one record with your
key value

>
>Does anyone else know of a better way to prevent duplicates?

--
Brian Bushay (TeamB)
Bbushay@xxxxxxxxx
.

Relevant Pages