Inventory Database

[S_DeLaire_2002]

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?

 

[adz2013]

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).]