Using DMax with DLookUp

[Gordon]

Hi,

This is probably very simple but it's got me stumped. I am using the
following as the control source for an unbound text box:

=DLookUp("fldVersionNoAndDate","tblConstants",
[fldConstantID]=DMax("[fldConstantID]","tblConstants")).

Access (97) gives me syntax error when I enter the above, but I'm
getting a "#Name?" error in the form control.

Can someone point out my (glaring?) error?

Thanks

Gordon

 

[Douglas J. Steele]

Your quotes are wrong.

=DLookUp("fldVersionNoAndDate","tblConstants",
"[fldConstantID]=" & DMax("[fldConstantID]","tblConstants"))

This assumes that fldConstantID is a numeric field. It it's text:

=DLookUp("fldVersionNoAndDate","tblConstants",
"[fldConstantID]='" & DMax("[fldConstantID]","tblConstants") & "'")

Exagerated for clarity, that's

=DLookUp("fldVersionNoAndDate","tblConstants",
"[fldConstantID]= ' " & DMax("[fldConstantID]","tblConstants") & " ' ")

 

[Gordon]

Thanks Doug,

Job done. I knew it was simple <grn>.

Gordon