Data Entry Matches

  • Thread starter Thread starter Grinbin
  • Start date Start date
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
 
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"
 
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"
 
Back
Top