Search issue

[karanvemuri]

the search is running fine,however a new record is being created in the DB by the search criteria which i give in the fields in the original form.

below is the code,

strCriteria = "[Agent Name] = '" & Me.[Agent Name] & "' "
strCriteria = strCriteria & "AND [DetailDate] = #" & [DetailDate] - 1 & "#"

[pdebaets]

I don't think that [DetailDate] will ever be equal to [DetailDate] - 1

Try this:

strCriteria = "[Agent Name] = '" & Me.[Agent Name] & "' "
strCriteria = strCriteria & "AND format([DetailDate],'yyyymmdd') = format(#" & Date() - 1 & "#,'yyyymmdd')"