Duplicate record

[L]

I am creating an online database for data entry. Is there a way for me to
check
for duplication before the user adds the duplicate record to the database?

 

[Stefan B Rusynko]

Yes
Open the DB recordset using a Select for that record and check for EOF
If rs.EOF Then
'no dupe
Else
'dupe
End If
'close rs



|I am creating an online database for data entry. Is there a way for me to
| check
| for duplication before the user adds the duplicate record to the database?