Dlookup

[emanual4real]

I'm having trouble getting DLookup to work for me.
Here's what I've got: [Action Details] Table. [Action Query] query. [Action Form] form.

Query
SELECT [Action Details].employee, [Action Details].[Action Date], [Action Details].[Action Taken]
FROM [Action Details]
WHERE ((([Action Details].Employee)="username") And (([Action Details].[Action Date])>(DateAdd("d",-90,Date()))));



When the form opens, the query is updated based on the username to show all actions within 90 days for that user.
On the form, I have a textbox =Max([Action Date]) which shows me the latest date of the action taken.
The problem is another textbox, I want it to show the latest action taken.

I've been told I need to use Dlookup, but it is not working for me.
=DLookUp("[Action Taken]","[Action Details]","Max([Action Details]![Action Date])")

Any help would be appreciated.
TY

[June7]

Try:

=DLookup("[Action Taken]", "[Action Details]", "Employee='" & [Employee] & "' AND [Action Date]=#" & DMax("[Action Date]", "[Action Details]", "Employee='" & [Employee] & "'") & "#")

[emanual4real]

Ok, wow, that worked first try! Since I wasn't including the [Employee], was it trying to pull more than one record and can't display more than 1 in a textbox?

Thanks again!!!

[June7]

Domain aggregate functions return a single value, not records.

The DLookup returns value from first record it hits that meets criteria.

The criteria was bad syntax.