Using Multiple Check Boxes in Access 2003

[Cynthia]

Hi,

I haven't used Access in a while and I tried researching to no avail. I
have created a form and all I want to do is put groups of check boxs together
under specific categories and be able to check off more than one check box
under each category.

 

[Amy Blankenship]

I think you need to use unbound check boxes. You'll only be able to use
these on forms in "single form" view.

HTH;

Amy

 

[Cynthia]

When I use an unbound check box, I can't change my checked boxes on the
preceding and following forms. What am I doing wrong?

 

[Cynthia]

I figured out the check box issue so I can check off multiple boxes in a
record but when I go to the next record and check off boxes in that one it
changes the preceding record. How do I fix that issue?

 

[J_Goddard via AccessMonster.com]

Hi -

What is the underlying table structure? In order to do what you want to do
(if I understand correctly), each checkbox must be bound to a (different)
Yes/No field in the table.

John

I figured out the check box issue so I can check off multiple boxes in a
record but when I go to the next record and check off boxes in that one it
changes the preceding record. How do I fix that issue?

When I use an unbound check box, I can't change my checked boxes on the
preceding and following forms. What am I doing wrong?

[quoted text clipped - 13 lines]

 

[Cynthia]

That is what I need to do. I needed to set up each of the categories on the
table. Thanks.

--
Thanks!

Hi -

What is the underlying table structure? In order to do what you want to do
(if I understand correctly), each checkbox must be bound to a (different)
Yes/No field in the table.

John

I figured out the check box issue so I can check off multiple boxes in a
record but when I go to the next record and check off boxes in that one it
changes the preceding record. How do I fix that issue?

When I use an unbound check box, I can't change my checked boxes on the
preceding and following forms. What am I doing wrong?

[quoted text clipped - 13 lines]

under specific categories and be able to check off more than one check box
under each category.

 

[Amy Blankenship]

I figured out the check box issue so I can check off multiple boxes in a
record but when I go to the next record and check off boxes in that one it
changes the preceding record. How do I fix that issue?

If you use unbound checkboxes, you must use single form view. The check
boxes don't _actually_ change the values in other records, they simply
_appear_ to. You need to use the form's Current event to reset the
checkboxes.

HTH;

Amy

 

[Cynthia]

Thanks. I got it all figured out. One last thing. When the values show up
on the table they are a negative one. How to I make the show as a possible
one?

 

[Jeff Boyce]

Why do you care what the table uses to store a "check" (i.e., a True)?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[J_Goddard via AccessMonster.com]

I don't think you can make Yes/No fields show as positive values ( 1 ) when
viewing the table, but you can make them display as checkboxes:

In Table Design view,

1. Select (Click) the Yes/No field
2. In the field properties at the bottom of the screen, click the "Lookup"
tab
3. In the "display control" dropdown, select "Check Box" from the list

Do this for each of your checkbox controls.

You could make them show as 1 or 0 in a query by using

iif([TableField],1,0) as the column expressions.

John

Thanks. I got it all figured out. One last thing. When the values show up
on the table they are a negative one. How to I make the show as a possible
one?[quoted text clipped - 8 lines]

Amy

 

[Cynthia]

You are right. I will just convert it in a query.