Dlookup not working

[Al]

the following dlookup gives me error can anyone see any syntax error?

=DLookUp("[FollowupStatus]","tblFollowUp","[PatientID]='" & [PatientID] & "'
And [PatientContactDate] =" &
DMax("[PatientContactDate]","tblFollowUp","[PatientID]='" & [PatientID] &
"'"))

FollowupStatus and patientID are text fields. PatientContactDate is Date
field.
thanks
Al

 

[Stefan Hoffmann]

hi Al,

FollowupStatus and patientID are text fields. PatientContactDate is Date
field.

It's the date.

See http://www.mvps.org/access/datetime/date0005.htm

mfG
--> stefan <--

 

[TonyT]

Try;

=DLookUp("[FollowupStatus]","tblFollowUp","[PatientID]='" & [PatientID] & "'
And [PatientContactDate] = #" &
DMax("[PatientContactDate]","tblFollowUp","[PatientID]='" & [PatientID] &
"'") & "#")

TonyT..