Problem with checkbox on forms

[Dusten]

We used Access to create checksheets that are to be used every 12 hours. I made some changes to the form (added a couple new check boxes) they seemed to be working. But what i didn't notice is that when you checked one of those new boxes on the current form that it also checked the same box on the next form.....(the next days check sheet)



So there must be a setting that I missed that will only alow checkboxes that are checked to show up on the current form only....

I'm using a very outdated Access as well...I think 97.

Thank you in advance for any assistance.

[Bob Fitz]

Have you added a field to the forms record source and bound the check box to that field

[Missinglinq]

...when you checked one of those new boxes on the current form that it also checked the same box on the next form.....(the next days check sheet)

I assume by 'current form' you actually mean current Record, and going from there...the answer to Bob's question would have to be 'NO!'

The latest data entered in an Unbound Control, on one Record, will be the data that appears in that Control on every Record in the Form...that's how the Access Gnomes work, with Unbound Controls!

For the Control's data to be Record-specific, you have to do as Bob's response suggested...add a Field to the Form's Record Source and Bind the Control (a Check Box, in this case) to that Field, i.e enter the Field's name in the Control Source of the Checkbox.

Linq ;0)>