Create Error Message when adding new record

[Melee]

I have a macro for the menu bar that opens a form to add a new record. The record name property allows No Duplicates. I need an error message to appear if the new record entered has the same name as an existing one.

Currently, the form appears to accept data changes, but does not. This needs to happen as soon as the duplicate name is entered.

How can I do this easily?

 

[jlitondo]

Have you set the field that you do not want duplicated as either the form's underlying table's primary key or to Indexed with No Duplicates allowed (either one has to be set)? If so then do the following.
On the On_Error() event of your data entry form, type the following code;

If (DataErr = 3022) Then
MsgBox " duplicate data entry etc etc..."
If Me.Dirty Then Me.Undo 'if record modification was attempted, undo changes.
Response = acDataErrContinue
End If


note: DataErr # 3022 is Access's error num for duplicate record entry.

 

[Melee]

Yes, The record is the key field. I will give it a try. Thanks.