Using Multiple Check Boxes in Access 2003

  • Thread starter Thread starter Cynthia
  • Start date Start date
C

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.
 
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
 
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?
 
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?
 
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?
Click to expand...
[quoted text clipped - 13 lines]
Click to expand...
 
That is what I need to do. I needed to set up each of the categories on the
table. Thanks.

--
Thanks!


J_Goddard via AccessMonster.com said:
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?
Click to expand...
[quoted text clipped - 13 lines]
under specific categories and be able to check off more than one check box
under each category.
Click to expand...
Click to expand...
Click to expand...
 
Cynthia said:
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?
Click to expand...

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
 
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?
 
Why do you care what the table uses to store a "check" (i.e., a True)?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
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
Click to expand...
Click to expand...
 
Back
Top