duplicate data

[imdl]

Hi,

I am currently developing a database of invoices. I'd like to know if there's a way to put a message box that whenever a user enters a new record with the same invoice number as an existing record, the message box should say, "A record with that invoice number already exists."

imdl

 

[MStef]

Look at "DemoDupliNHSA2000.mdb" (attachment, zip).
Open form and try. Adapt it in your mdb.

 

[imdl]

it works. thank a lot for your help