stop information being put in twice???

[lainey]

how do i stop information being put in twice into database? can anyone help me??
thanks
lainey

 

[Fizzio]

Depends on the type of 'Data'. Do you mean 1 field eg invoice number or a collection such as a person's name and address. The easiest way is in table design, in the indexed property set it to Yes(No Duplicates). Access will then not allow the sama data to be duplicated in that field in that table .

HTH