Avoid duplicate entry

  • Thread starter Thread starter dawn
  • Start date Start date
D

dawn

Hi

A user can only have 1 entry per date. How do I set up the
form so that it checks to see if the user already have a
record for the date just entered?

Thanks
 
1. Open the table in design view.

2. Select the date field.

3. In the lower pane, set the Indexed proeprty to:
Yes, No Duplicates.

If you intended that the combination of UserID + Date must be unique, you
can still do that with a unique index. In table design view, open the
Indexes box, and make a unique index on the 2 fields (index name on the
first row, but 2 rows of fields).
 
Back
Top