Search results

Thanks Bob, Attached "sample.zip" is a sample with ProdID as SID. It is Access 2007 data. Thanks again :)

Hello John and Bob: Unfortunately both your codes did not work. The ProdID is actually also the primary key for the table, does this will affect it?:confused: Is (are) there anything I need to declare at the beginning of the codes lines? Thanks :)

Redirecting the focus (open) the duplicated record for editing Thanks so much for your fast response guys. I 'll enthusiastically try it. Meanwhile the next step I am trying to do (as the title says) would be to redirect the focus (or to open) the duplicated record so that I can make update...

I need to capture & display a msg that tell that I 've just entered duplicate data on the field of a record. The msg has to appear immediately after finish typing the duplicated field (before I get to the last field of the record). I use "ProdID" as the reference field in PRODUCT table. Also...