I know that this is probably so simple that I seem to be over complicating things.
I am working on creating a database to track our students time and reason for being in my area. I have created my table, built a form for the student to scan their badge, it auto-fills in the first/last name, what part of the curriculum they are in, and the reason they are here. I then have them click the Badge In button, which adds that information to the table (I was impressed I got this far!)
What I need now, is a way for them to scan their badge (preferably the same line they use to badge in) and hit a Badge Out button. This button will then find their number in the table, and timestamp that record in the Time OUT column, and be blank for the next student. Where I am getting stuck is that I am trying to use the Update Query method, but can't figure out how to make it change just that 1 record, and not the whole table.
Any help would be greatly appreciated!
Patrick