Formula change (1 Viewer)

Hi!

I ask for your assistance in the following matter:
I have a form with a textbox for the warning about the possible duplication.
In the control source I have a formula

"=IIf(DCount("*";"[Pacient]";"[ID]<>" & Nz([ID];0) & " And [LastName] = '" & Replace(Nz([LastName]);"'";"''") & "'")>0;"Duplicates possible!";"")

that I copied from one of the Microsoft template and slightly adjusted.
I admit that I do not know much about Access, but if I understand correctly, the formula checks whether there are duplicate entries in the [LastName] field. I want to know how to check for duplicate entries in more than just one field, for example for the fields [LastName] and [FirstName]?

I use Access 2007 and 2010.

Some language packs use ; as the operand separator rather than , so I am assuming that the seim-colon is correct for your language pack.

=IIf(DCount("*";"[Pacient]";"[LastName] = '" & Me.LastName & "' AND [FirstName] = '" & Me.FirstName & "' AND [somenumericfield] = " & Me.SomeNumericField))>0;"Duplicates possible!";"")

Pat Hartman said:

Some language packs use ; as the operand separator rather than , so I am assuming that the seim-colon is correct for your language pack.

=IIf(DCount("*";"[Pacient]";"[LastName] = '" & Me.LastName & "' AND [FirstName] = '" & Me.FirstName & "' AND [somenumericfield] = " & Me.SomeNumericField))>0;"Duplicates possible!";"")

Click to expand...

It works. Thanks.