Display the Already Existed Record value

[irsmalik]

Hello Friends,
I got the solution one of my problem how to display a message if record already existed.

Now I want to display its value with the message.
Suppose, If I entered the Drawing No. 100
There should be a message that "
"Drawing No. 100 is already existed"

Please any1 , (especially Veena) pls help again. Thanx

[QVeen72]

Hi,

Change message box like this :

MsgBox "Drawing Number " & dwg & " already Exists...", _
vbCritical, "Duplicate Entry"

Regards
Veena