Dependent checkbox

[Guest]

When a user checks a checkbox I want to verify that 8 other checkboxes are
all checked, and if one or more are not, then I want to open a warning form.

I'm ok with opening the form, but how would you code a check on 8
checkboxes? I was thinking maybe I could add their values up, and if the
result is <> -8 ...

 

[ifoundgoldbug]

could you not also use a select statement and check thier Bool values?

 

[Guest]

Hi Ricter,

Glad to hear that it works for you. I think your approach was the easiest.
You could have interrogated each checkbox individually, but that would have
taken a lot more code.

Good luck on your project.

Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Guest]

It works, Tom, thank you. I posted thinking there might be something
"fancier".