Duplicate record

L

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?
 
S

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?
 
Top