I am building a sign in -sign out database and am trying to get it to work right. I would like the user to hit the Sign out button, then be prompted to enter a badge number, then once they enter it return the data in the form for them to update the sign out date/time. I have a query created with the prompt for badge number and the Edit date is null criteria to return the correct record but it returns in the query datasheet result and not in a form result. I am not sure how to do this and need some help. Or even if they entered the badge number at the prompt and it displayed the info and said is this you and they hit ok and it set the exit date/time automatically.
Also I can't seem to get the time to show up in my date time fields for Entry and Exit Date. It would be cool to get the Entry date and time autopopulated when the record is touched but I am working on that as well.
Any insight would be awesome
I added the database as well
Thanks