DCount Question

[perryc]

Anyone can point to me what is wrong with this statement?



If DCount("*", "tbl_Demographic", "[DOB] = '" & Me.DOB & "'") > 0 Then
Msgbox "NameExist"
End If

DOB = Date Of Birth (e.g. 7/1/1956)

I have a Form with a field DOB but whenever I entered a new DOB, I would like it to look up if the same DOB exists in another table (Demographic)

Thanks in advance.

Sincerely,
Perry

[pbaldy]

Different delimiter required for date/time fields:

http://www.theaccessweb.com/general/gen0018.htm

[pbaldy]

By the way, more than one person can have the same DOB. You might want to compare DOB and name or something.

[perryc]

That's it. Ty.

[perryc]

Can you give me tips on why this combo does not work?

If DCount("*", "tbl_Demographic", "[DOB] = #" & Me.DOB & "#" & " AND " & "Patient='" & Me.[Patient] & "'") > 0 Then

[perryc]

never mind... I did not name the Field correctly.

[pbaldy]

Just back from lunch; glad you got it sorted.

Edit: you had working quotes, just more than necessary.