Check Box

B

Becka

I've set up an Access form with a checkbox. The problem is when you click
the checkbox for one form, every form then has that box checked. The help
file is not helping! How can I get this to work right?
 
R

Rick B

when you check that box on one form \, every form has that box checked? Did
you fail to mention that this is a continuous form? Did you mean to say
that when you check it on one RECORD, all RECORDS have it checked?

Sounds like you are using an unbound checkbox on a continuous form. You
need to add the field to the table and make it a bound checkbox. If you
'check' records 1, 5, and 8 how does the database know that unless you store
that in the table?

Add the field to your table.

Post a more accurate and detailed question if this does not help you.


Rick B
 
B

Becka

Ok, I'm a beginner on Access and don't have all the correct terms down,
sorry. When I change one "record" all records record that change. The form
is a single form. The tool box help indicates that this is an unbound check
box. How can I change it to a bound one?

Thanks!


Rick B said:
when you check that box on one form \, every form has that box checked? Did
you fail to mention that this is a continuous form? Did you mean to say
that when you check it on one RECORD, all RECORDS have it checked?

Sounds like you are using an unbound checkbox on a continuous form. You
need to add the field to the table and make it a bound checkbox. If you
'check' records 1, 5, and 8 how does the database know that unless you store
that in the table?

Add the field to your table.

Post a more accurate and detailed question if this does not help you.


Rick B
Click to expand...
 
R

Rick B

You would go into your table design and add a new yes/no field. Save your
table and go back to your form and display your filed box (where you drag
fields to the form) and add it from there. If this form is based on a
query, then you will have to include the new field in the query before it
will be available in form design-view.

Rick

Becka said:
Ok, I'm a beginner on Access and don't have all the correct terms down,
sorry. When I change one "record" all records record that change. The form
is a single form. The tool box help indicates that this is an unbound check
box. How can I change it to a bound one?

Thanks!
Click to expand...
 
B

Becka

Thanks for your help! I looked further at what I had done and saw that I had
not checked the properties on the actual check box, but instead the title for
the box. I went to the properties and saw I had no Control Source. I added
the name from the column on the table and it is working!
 
Top