Hi!

I am developing an invoice log database and I am having a hard time 

validating data entered in a form.

I would want access to warn the user if he has entered duplicate data.

To check this Access should first check on three fields.

-Vendor ID

-Vendor Invoice

-Vendor Amount

If all three are are similar on two records, access should give a warning.



Can the user override this warning too?



Appreciate if somebody can help me with the code.



thank you.

Before adding the data from form to the Database,

first u try connecting to the database and query on

all the three field's values you have stated. If it is

then dipslay a server side validation message to the

user on the same page in which the form is present and

fill the fields on the form with the data entered.

else add it to the database.



If you do have more doubts on this, mail me.



Regards

Vijay.G



--- Hazel Narvaja <hnarvaja@h...> wrote:

> Hi!

> I am developing an invoice log database and I am

> having a hard time 

> validating data entered in a form.

> I would want access to warn the user if he has

> entered duplicate data.

> To check this Access should first check on three

> fields.

> -Vendor ID

> -Vendor Invoice

> -Vendor Amount

> If all three are are similar on two records, access

> should give a warning.

> 

> Can the user override this warning too?

> 

> Appreciate if somebody can help me with the code.

> 

> thank you.

>