OK thank you,,
last ask,,,
If DCount("*", "Suppliers", "SuppName like '*" & tt & "*'") > 0 Then
If MsgBox("Duplicated Full Or Part?", vbQuestion + vbYesNo, "!!") = vbNo Then
''SuppName.BackColor = vbRed
Me.SuppName.Undo
Cancel = True
End If
End If
how can i grab the full name that`s saved and...