It came to pass on 07/08/96 that SYLVIA CHERRY wrote concerning Duplicate 
Records...
 
SC> I'm new to using Access.  Is there a way I can set Access up when
SC> designing a form that it will alert me when I am keying in a
SC> duplicate record.  I would
If you make the fields you want to be unique the primary key, Access 
won't let you save the record.  This is probably the easiest way.
Cya Matt  ===> matthewj@brisbane.dialix.oz.au
               New Resolution Communications
 * RM 1.31 3332 * Expert: "ex"=a has-been. "spert"=a drip under pressure.
--- 
---------------