Validation Rule - Unique text in Form regarding based table

[Kimal]

Hello



It's my First post at this forum so please be forgiving.

I have a Form based on Table with Products. I have a field with EAN Codes - they are indexed and only unique text are allowed. My form is for adding new products into Table.Products. When i add a product with EAN Code that arleady exists i have access error - it's normal because of ean's unique field property in table.

But i dont want to have this error i want to use Validation Rule in Form field to have my own text if new ean doesn't meet the validation rule.

Please help me create this Validation Rule.

Regards
Kamil

[orange]

I don't think you can do it with a validation rule. I'd suggest a small routine to see if the record already exists.
Typically this is done with a DCount function.

In plain English, using the "text that should be unique", you check to see if there is a record already in the table with that "text". If the DCount is > 0, then the "text value" already exists - so give a message that that record already exists.

[Kimal]

OK I Will try with before update :>

Thx