Prevent duplicates in multiple fields (1 Viewer)

[aftab1965]

Dear Friend I need your help.
I have a database "Student" having only one table "Registration" which has "ID, Studentname, FatherName, Class and Group" Fileds, and A Form "frm_reg"

I want to prevent duplication of records, while entering data into "frm_reg" form in multiple field.


Sample data is attached herewith.

 

[Ranman256]

Key the table on those fields, then no more dupes.

 

[sneuberg]

After you decide what constitutes a duplicate you can check for that condition in the form's before update. Below is an example of what the form's before update might look like if duplicate combinations of StudentName and FatherName were considered duplicate records.

Private Sub Form_BeforeUpdate(Cancel As Integer)

If DCount("*", "registration", "StudentName = '" & Me.StudentName & "' AND FatherName = '" & Me.FatherName & "'") > 0 Then
    MsgBox "The combination of student name and father name must be unique"
    Me.FatherName.SetFocus
    Cancel = True
End If

End Sub

 

[aftab1965]

Thanks sneuberg
it works fine for me
Regards