Check mark box not clearing on next record

[Porkchop]

I have a form with a check mark. The form is viewed as a continuous form.
When the check mark is checked, then all of the records(continuous form,
next form) the box is then check before we got to that form.

Help.
I can supply code for form if you need.
Thanks
-Porkchop

 

[Douglas J. Steele]

Presumably your check box is unbound (not linked to a field in the form's
recordsource). That's how it works with continuous forms: make a change to
an unbound control, and it applies to all instances of that control.

 

[Wayne-I-M]

Hi

It sounds like an unbound check box. Bind the box to a yes no field in the
table.

 

[Porkchop]

Wayne,
Ok, question then, can I make a new table and use, or do I need to add a new
column to table and use?
Thanks again for your help.
-Porkchop

 

[fredg]

Wayne,
Ok, question then, can I make a new table and use, or do I need to add a new
column to table and use?
Thanks again for your help.
-Porkchop

If the table is the record source of the form, just add a new check
box field to the current table.
Then, on your form, set the control source of your check box to the
newly added field.

 

[Porkchop]

That Worked!!
Thanks!
-Porkchop

If the table is the record source of the form, just add a new check
box field to the current table.
Then, on your form, set the control source of your check box to the
newly added field.