I created an inventory database to keep inventory of our PC's. I am new at working w/ Access and I need help. I have a text box [IP Address] and I need to make it so that a duplicate IP Address cannot be entered.
How do I make my form so that once an IP Address is entered the same IP Address cannot be entered again? I already have a primary key. How do I index it?

Please only post questions in one Forum. If you can't decide which to use, General is always a safe bet. adz2013 gave you a possible solution in your other post in this same Forum. Post a reply there if you run into further difficulties.