Automatically check another checkbox

[Chris]

Hello,

I am not a skilled programmer, but I've been tasked with being the 'go
to' guy for Access DB development.

I have a DB that has a form that I use to enter business items and
personal information. This is to document a business process we use.
Fields included are 5 yes/no check boxes that are related to those
personal items (for example: Age is a checkbox, and if it is checked,
it represents we are tracking that information.)

My question is, there is another checkbox we use that indicates that
we are using personal information in this data process; I would like
to have that checkbox automatically become checked if one of the 5 yes/
no check boxes for the personal info is checked in the form.

Any help/code examples would be appreciated.

Thanks

 

[strive4peace]

hi Chris,

make a calculated control:

=iif(([chk1] + [chk2] + [chk3] + [chk4] + [chk5])=0,0,-1)

WHERE
chk1...chk5 are the names of your checkbox controls

Warm Regards,
Crystal

*
have an awesome day
*

 

[Chris]

hi Chris,

make a calculated control:

=iif(([chk1] + [chk2] + [chk3] + [chk4] + [chk5])=0,0,-1)

WHERE
chk1...chk5 are the names of your checkbox controls

Warm Regards,
Crystal

  *
    have an awesome day
  *

Hello,

I am not a skilled programmer, but I've been tasked with being the 'go
to' guy for Access DB development.

I have a DB that has a form that I use to enter business items and
personal information. This is to document a business process we use.
Fields included are 5 yes/no check boxes that are related to those
personal items (for example: Age is a checkbox, and if it is checked,
it represents we are tracking that information.)

My question is, there is another checkbox we use that indicates that
we are using personal information in this data process; I would like
to have that checkbox automatically become checked if one of the 5 yes/
no check boxes for the personal info is checked in the form.

Any help/code examples would be appreciated.

Thanks- Hide quoted text -

- Show quoted text -

Hi Crystal;

Thank you for your response; I'm not sure I follow about a calculated
control. How would I set that up and where would I put it in the
form? I'm afraid I'm a little bit slow in this area of Access..

 

[strive4peace]

Hi Chris,

you put the equation in the ControlSource of a textbox control

for better understanding of the basics of Access, download and read this:

Access Basics (on Allen Browne's site)
http://www.allenbrowne.com/casu-22.html
8-part free tutorial that covers essentials in Access

Allen has a wealth of information on his site; after you get to the
bottom of this link, click on 'Index of Tips'

Warm Regards,
Crystal

*
have an awesome day
*

hi Chris,

make a calculated control:

=iif(([chk1] + [chk2] + [chk3] + [chk4] + [chk5])=0,0,-1)

WHERE
chk1...chk5 are the names of your checkbox controls

Warm Regards,
Crystal

*
have an awesome day
*

Hello,
I am not a skilled programmer, but I've been tasked with being the 'go
to' guy for Access DB development.
I have a DB that has a form that I use to enter business items and
personal information. This is to document a business process we use.
Fields included are 5 yes/no check boxes that are related to those
personal items (for example: Age is a checkbox, and if it is checked,
it represents we are tracking that information.)
My question is, there is another checkbox we use that indicates that
we are using personal information in this data process; I would like
to have that checkbox automatically become checked if one of the 5 yes/
no check boxes for the personal info is checked in the form.
Any help/code examples would be appreciated.
Thanks- Hide quoted text -

- Show quoted text -

Hi Crystal;

Thank you for your response; I'm not sure I follow about a calculated
control. How would I set that up and where would I put it in the
form? I'm afraid I'm a little bit slow in this area of Access..