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?