Check existing record in a table 1

[nat35]

Hi there,
I have an add form and a table with a multiple-field primary key.How can I check if the record already exist in table.I also want to get rid of the long access massege and send mine that duplicate is already exist.Is it any easy way to do it
Thanks in advance

 

[Rolliee]

open a recordset clone and search for the key. If nomatch is true, the recordset does not have the value you are looking for.

want a sample, send your email address.

rollie@bwsys.net

 

[nat35]

Thanks Rollen,
That is exactly what I need.
I want to give you a star but i don't know how.

 

[Rolliee]

Thanks Nat,

Just click on the 'Mark this post as a helpful/ expert post.'