prevent similar data entry?

[ariansman]

Different users are putting data for our customers. How can we figure if we are making a duplicate record for the same costumers and prevent that? I mean for example a costumer name is “Scarlett Johansson”, and a record is made for her. Then another user is entering the same data for the costumer, but the user types” Scarlett Johanson”. A typo is here. Can access warn us that a similar costumer name already exists and let us decide whether to proceed with data entry or not?

[aytee111]

The most important thing to do is make entry of the name a combobox.

Then in the AfterUpdate of the combobox you could create a routine to check different things. For instance, it could separate out the first name and last name and then show the user all names with the same first name, or same last name. You could also make some design decisions about what to match on - Access is very specific! Such as the first few characters or the last few or mix and match. You will have to decide beforehand what could work.

[orange]

ariansman,

When you cross post --same question on different forums -- tell users you have done so.

cross posted http://www.access-programmers.co.uk/...d.php?t=290542

Here is why