Dlookup combined with Dlast

[JamesN]

Hi,

I'm trying to combine a dlookup and dlast to return a value. Currently I have the Dlast below which returns the commitments from last meeting field for the last entered record. I need to add a bit into the formula which references the agent selected in the form I have to return the last entry for a particular agent which is selected (agent is selected from combox - "agent". Is this possible?

=DLast("CommitmentsFromLastMeeting","OperationCoachingWarehouse","ID")

 

[CJ_London]

you would use the criteria something like (assuming agent is a string and not a numeric ID)

"agent='" & me.cboAgent & "'"

Note that DLast will only return the last record (in the table for that criteria) - not necessarily the last one entered - because db's store data randomly.

See this link

https://msdn.microsoft.com/en-us/library/office/aa211977(v=office.11).aspx

 

[JamesN]

Thanks for the response CJ London. How would that fit in with the DLast formula in my post? Apologies i'm not familiar with how to phrase the two together

 

[CJ_London]

suggest read the link I provided which tells you how to use the dlast function. At the moment your criteria is just [ID] which is meaningless

 

[JamesN]

Cracked it. cheers