By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,777 Members | 1,311 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,777 IT Pros & Developers. It's quick & easy.

Checking for Duplicates

P: 10
Hi, I have a question regarding duplicate entries.

Basically I have a simple database with a main table called contacts. This table has 2 fields, contactsid and contactsnum.

The main form has a combo box select which triggers a subform query to display records that are relevant sorting via the contactsid field.

I would like to be able to prevent duplicates being entered in the contactsnum field for each group of contactsid displayed by the query.

I was hoping I could perform validation by using the After Update property but its not available in the query.

Jan 29 '08 #1
Share this Question
Share on Google+
2 Replies

Expert 100+
P: 1,356
In the Tables design view look at the properties for the field in question there you can prevent duplicates. You will want to add an input mask there so all the numbers are formatted the same, this will help prevent any duplicates since a simple typo such as an additional space or such will unknowingly create a duplicate.
Jan 30 '08 #2

P: 10
Thanks Denburt,

I couldn't use that method as the numbers were not unique. I decided to use seperate tables for each.

Much easier for me once it was set up!

Feb 4 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.