Preventing a user from causing a duplicate

C

Chris

Hi Group

I hope someone can help with this one.

I have a form, frmClientDataEntry, containing basic details of a client.
When the user clicks a button they can edit these details. One of the
controls has the underlying table field set to no duplicates and I would
therefore like to have some code which will presumably go in the before
update event of the control so that the user sees a message box after the
application finds a duplicate saying "Duplicate entry. View record?" with
Yes and No buttons where clicking Yes takes the user to that record and the
entry in the control is reset to the original entry.

I am fairly new to VBA but keen to learn more.

Any help is appreciated

Thanks

Chris
 

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

Preventing duplicates 3
Prevent duplicates in sub form 1
Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0
Prevent duplicates on form level 4
Duplicate a Record 13
Problem with code to catch duplicate Primay Key 27
How can I duplicate a record 2
Form Coding Issue, Help Please 2

Top