Access DLookup

Try this.  And what is the error you are getting ?

DLookUp("Time Start","qryLastAuditLogDate","Time Start = " & "#" & [Time Start] & "#")

still get an error#

What is the error number ?

It's a lookup on a form... #error

Do you have
=DLookkup()

(equal sign in front of DLookup) ?

And where does [Time Start]  exist ?

Here's the sql

SELECT Max(tbl_Inactivity.[Time Start]) AS [MaxOfTime Start] FROM tbl_Inactivity;

Select allOpen in new window

(note the brackets around Time Start

=DLookUp("Time Start","qryLastAuditLogDate","[Time Start] = " & "#" & [MaxOfTime Start] & "#")

or

=DLookUp("Time Start","qryLastAuditLogDate","[Time Start] = " & [MaxOfTime Start])

Last Audit Log Date is lookup

I get an error : #Name? on both

"Last Audit Log Date is lookup"
Not sure what you mean ?

You are using DLookup to grab a value from a query, right ?

Theses ... more brackets

=DLookUp("[Time Start]","qryLastAuditLogDate","[Time Start] = " & "#" & [MaxOfTime Start] & "#")

or

=DLookUp("[Time Start]","qryLastAuditLogDate","[Time Start] = " & [MaxOfTime Start])

Yes using Dlookup to grab a value from a query. Tried both and get #Name?

If you run that SQL by itself, what does it return ?

Why not use DMAX, and do away with the query as the control's record source:

=DMAX("[Time Start]","tbl_Inactivity")

Thanks

Sorry for the confusion. It was late :-)

No problem Joe