How to display a message telling that the record already exist?

[PNC]

I have a form where users enter a new product code manually and the users would like to know after entering the new product code if the record already exist...right now there's a message which is error 3022 after entering all the fields in the forms, but they want the message after entering the first field.

 

[Durkin]

Use the Dlookup function to find out if the no. is already being used. Durkin
alandurkin@bigpond.com

 

[Rohdem]

I assume that they get the error because you have a primary key set up on the product code. If this is the case, you could simply try to save the record on the after update event of the first field.

Docmd.Runcommand acCmdSaveRecord

This will cause the error message to be displayed immediately when a duplicate value is entered.

Mike Rohde
rohdem@marshallengines.com