[RESOLVED] dslookup to find when data was submitted last

[shabbaranks]

Hi all,

I have an Access 2007 form which adds the current user info and adds it into a textbox on the form. On submit that field then gets added to a table and stored. I also have a field within that table which stores the date/time which the records were submitted. What I am trying to do is display in a textbox when the last record was submitted of the perticular user - which would be the current user.

Could anyone assist me on doing this please?

Thanks

[shabbaranks]

Sorted this one with

=DMax("[Time_Of_Submission]","TimesheetTable","sUser='" & [LoggedInUser] & "'")