I am setting up a database in Access 2007 to track equipment that is checked out and returned everyday several times a day. I have the checkout and return times working, but I need the Returns form which only has a text (to enter the equipment ID) to look up the last matching equipment ID record with no return time and insert the NOW() in that record. The object here is to quickly allow a clerk to simply scan in and out equipment without any clicking. It works presently with auto tab and input masks but there is a new record for every checkout and return. So I have to use a report to compile the associateID, checkout and return time instead of having a table that shows the User ID, Equipment ID, the checkout time, and return time in a single record. <img]http://i39.tinypic.com/f54txx.jpg[/IMG]
I am new to access and I cannot figure out which command in visual basic I would use to have the returns form look up the last entry for the Equipment ID when it is entered and insert the return time in the return feild.