Error Msg, would create duplicate

  • Thread starter Thread starter Radar
  • Start date Start date
R

Radar

Help! looking a way to bring up the Dup Record in place of the error
msg.
Thanks
 
You could trap the message in the Error event of the form.
DataErr will be 3022 for a duplicate index error.
Display your own MsgBox, and set Response to acDataErrContinue.

Alternatively, use Form_BeforeUpdate to DLookup() the existing record if you
prefer to avoid the failed write attempt.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Best Gmail Backup Tool to use in 2025? 3
Outlook 2016 - "Run-time error '287': Application-defined or object-defined error" while using CurrentItem.Saveas or CurrentItem.HTMLBody 4
Excel Providing user message when RED X clicked & properly closing application. 2
Which is the best MBOX Converter Tool different formats conversion? 4
Msg: You are about to append..... 5
Duplicate Entry 4
DCount Error 2001 1
Pls help with Excel Function 1

Back
Top