Dlookup in VB Code using "LIKE"

[kb178]

I have this code set up to look for duplicate names, which if a dup is found a message pops up:

If Not IsNull(DLookup("ID", "[tbl]", "[First Name]='" & Forms![frm]![First Name] & "' AND [Last Name] = '" & Forms![frm]![Last Name] & "'&quot) Then ...

This works with an exact dup. But if John J. Doe is already entered and John Doe is entered, the duplicate is not found. What's the correct syntax for [First Name] Like Form!frm![First Name]... ?

Thanks!

 

[zyon]

Don't use Like...
I think is better to use the 'where' clause

for example:

select * from database where name='" & text1.text & "'"

'bind the data retrived and then use this:

if (datasource.recordset.bof) and (datasoucr.recordset.eof) then 'BOF and EOF true = no record in the current recordset
[enter your addnew method]
else ' there are anything in the current datasource
[enter you validation code]
endif

instead of bof and eof u can use the .recordcount
if recordcount=0 (nothing) recordcount =1 (anything)

bye

 

[kb178]

How is that different from what I have? If the where clause has the same thing, it's going to pull only identical data like it already does.