Need help creating a volunteer time tracking database

[stacey]

I have a form set up with a drop down box for them to chose their name and
then I have a sign in button and sign out button but I'm not sure how to
configure them so that it will log the time in when they click the sign in
button and log the time out when they click the sign out button and be able
total up their time? Need ASAP.

 

[butboris via AccessMonster.com]

On the On Click event of the command buttons have
Me.[Name of Sign On field to be updated] = Now()
this will insert the current date and time into the sign on field

Do the same for the sign off button

then have a text box to display the calculated time by using DateDiff()