R
Radar
Help! looking a way to bring up the Dup Record in place of the error
msg.
Thanks
msg.
Thanks
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
Allen Browne
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.
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.