dlookup help last value

[bw2601]

I am trying to look up the last date entred into a table. the date is the primary key.

i want to compare the last date entered with the current date, and then display a message box if they match.

i have the message box done, that was the easy part, but now i seem to be having a lot of problems with dlookup. i have never used it before and could use some pointers in the right direction.

thanks in advance for any help.

 

[PaultheS]

You probably want to use DMax.

If DMax("[DateEntered]", "[tbl: My Table]") = Format(Now(), "Short Date") Then
    MsgBox "The last entry was today!"
Else
    'they didn't match
End If

You can reformat the date depending on how it's stored in your table.

 

[gol4]

to look at the last date entry look at Dmax instead of dlookup

 

[bw2601]

Thank you so much, worked like a charm!!!

you rock!!!