Check Boxes on Form in Access

[junglej815]

Hello,Hoping someone could help out and have some info on this.I have a form in Access that is used to track employee start times and finish times. I have a DateDiff formula set up so that when you enter a start time and finish time is calcuates it automatically and it goes into a " total " box. My problem with that is that I need to differentiate between whether the time is considered " Travel Time", "Break Time ", or " Lunch Time ". I was thinking about doing check boxes so that the time can be calcuated and then I'd just select which type of time it was. Right now if i choose and click on a check box then that choice remains selected on every record in the database.How can I get it so that I can make my choice on one record and then go to a separate record and choose a different checkbox and so on...?Thanks,Joe

[ranman256]

Sounds like the form is setup wrong. Each check box must have its own field in the table. Show the records as tabular and the form default view as Continuous Forms.
Now you can check separate records.

If these checks are NOT fields...the checkboxes on the form must be UNBOUND. Not connected to any fields in the table. Then a query would update the 1 record.

[junglej815]

Thanks for the reply. Turned out I didn't choose the control source for each check box. Once I did that it worked the way that I was hoping it to. Thanks again.