Checked box automatically checks for subsequent records

[Darcy]

I created a form with 'dummy' checked boxes.

We wanted the form to mimic a survey. The survey had yes-no questions with
the answers 'yes' and 'no' as separate boxes next to each other horizontally.

Question: Yes
No

I therefore created one checked box to feed into the table as a binary
'yes-no' (this one was labeled 'yes') so that checking the box resulted in a
'yes' and leaving the box blank resulted in a no. The box would be left
blank if the person entering the data clicked the 'no' box right next to it
(the dummy box).

The dummy box, which is not associated with any value or variable, is
presenting us with two issues. 1) it's a different color than the other
boxes (a blue grey) and more importantly 2) checking the box results in all
subsequent records also being checking.

I would appreciate any advice on how to solve those two issues! Plus, any
suggestions on how to create 'dummy' boxes for future forms (a bit late to
change this one...).

Thanks!!

 

[XPS350]

I created a form with 'dummy' checked boxes.

We wanted the form to mimic a survey.  The survey had yes-no questions with
the answers 'yes' and 'no' as separate boxes next to each other horizontally.

Question:                                      Yes                          
   No

I therefore created one checked box to feed into the table as a binary
'yes-no' (this one was labeled 'yes') so that checking the box resulted in a
'yes' and leaving the box blank resulted in a no.  The box would be left
blank if the person entering the data clicked the 'no' box right next to it
(the dummy box).

The dummy box, which is not associated with any value or variable, is
presenting us with two issues.  1) it's a different color than the other
boxes (a blue grey) and more importantly 2) checking the box results in all
subsequent records also being checking.

I would appreciate any advice on how to solve those two issues!  Plus, any
suggestions on how to create 'dummy' boxes for future forms (a bit late to
change this one...).

Thanks!!

I do not have a solution for the dummy boxes all being checked.

For the future you can consider to use radio buttons instead of check
boxes. You don't need dummy boxes then. Both the yes and no button
will be associated with the table field.

Groeten,

Peter
http://access.xps350.com

 

[John Spencer]

The problem is that an unbound control in a continuous form is really just ONE
control shown many times. So you check or uncheck that one control, all the
other "views" of that control change.

Also, unless you set the control to have a default value of 0, it will have a
value of null until it is checked. That is why the checkbox control appears
to be greyed out.

If you want to have the choice of entering Yes or No or leaving the item
blank, your best bet is probably to use an option group with two checkboxes
and bind the option group frame to your field.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

 

[Duane Hookom]

You might want to consider binding your answers to an option group consisting
of check boxes with the yes value of -1 and the no value of 0.

You can't really use unbound "dummy" controls in a continuous form. Every
instance of the control will have the same value.

 

[Darcy]

Thank you, Peter.
I am completely new to Access, and having trouble figuring out which is the
radio button (even after searching through help). Is that the option button?
I can't seem to find an object that gives me two objects instead of one
(with clicked being yes and blank being no)

Groetjes
Darcy

 

[Darcy]

Thank you, John.
I did change the default and solved the color issue. Thanks!

I played around with having an option group with two checkboxes. I
understand ti now, somewhat. I'm still not sure how to bind the group option
to the field.
D.

 

[Darcy]

Thank you, Ken! I will definitely email you.

D.

 

[XPS350]

Thank you, Peter.
I am completely new to Access, and having trouble figuring out which is the
radio button (even after searching through help).  Is that the option button?
 I can't seem to find an object that gives me two objects instead of one
(with clicked being yes and blank being no)

Groetjes
Darcy

I am not sure about the proper name in english because I use a dutch
version of Access. You place a "groepsvak" (= OptionGroup?) on your
form using the wizzard that will guide you through the proces.

A radiobutton is a round white button that turns black when you select
it. The other buttons in the group turn white when you do that.

Later I realised that you can also use check boxes in an optiongroup.
As mentioned the good thing about an optiongroup is that all boxes/
buttons in the optiongroup are associated with one table field. Every
box or button represents a value (Yes or No in your case).

Peter
http://access.xps350.com