Data Entry Matches

G

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
 
R

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"
 
R

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