Data Entry Matches

[Grinbin]

Hi, hope this is in the right place,

I have a database set up where I need to have some sort of warning/attention
signal if I enter the same information, eg name, more than once. Is this
possible? I.E. I need to be made aware if data entered in a form field is
the same as in another record

 

[Ryan]

Use the Dlookup function. It would look something like this.

If Not IsNull(DLookup("Name of the field you dont want to repeate", "Name of
the table the field is in", "Name of the field you dont want to repeate =
[Name of the textbox on the form you are using to add the new record]")) Then
MsgBox "Your warning"

 

[Ryan]

Use the Dlookup function. It would look something like this.

If Not IsNull(DLookup("Name of the field you dont want to repeate", "Name of
the table the field is in", "Name of the field you dont want to repeate =
[Name of the textbox on the form you are using to add the new record]")) Then
MsgBox "Your warning"