Check the Duplicate Value.

[mkkashif]

when adding new record if id has duplicate value the message appera (default message from microsoft).
how can we put our message.on before update event.
not using macro.
in vb code.???

 

[apachee]

I believe that is done under "Design View" of your table under "Validation Text" !

That text is displayed everytime an MS Access error occurs!

U can also define error traps in which text is also displayed under "Validation Rule"!

 

[mkkashif]

This is not helpful

Dear
this is not helpful
send me the code which we can use for avoiding dupplicate value.
message appear when the customer type the same value which already in the table.
i think the event for this before update.

 

[apachee]

In the table design set to your ID 's index to "No duplicate".

Then under "Validation text" type in "YOUR MESSAGE WHEN DUPLICATE OCCURS".