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?

In the table make the ip address the primary key. Or you can just index it.

[This message has been edited by adz2013 (edited 02-06-2002).]