Craig has attended:
Access Intermediate course
Access 2007
Can you stop people entering the same data twice?
RE: Access 2007
Craig,
I hope this answers your question.
Yes, there is a way of doing this. When designing a table (be in Tables and Design mode), on the bottom left-hand corner you can choose to not allow Duplicates (Index : Yes(No Duplicates)).
If this does not answer your question, please come back to us.
Thank you
Greg