I am working on a form in Access and want to determine how I can click on one bound checkbox and have it select itself and other bound checkboxes, as well as feed those selections back to the underlying table. My form intakes information about events I am tracking, including the locations. Everything on the form is bound to a table. I have many locations and some are described as Top 10. I would like to be able to select my "Top10" check box and have the corresponding 10 cities checkboxes be selected, as opposed to selecting all 11 boxes individually. For example:
Top10 = True Then
Atlanta, GA = True
London, England = True
Hong Kong = True
etc.
etc.
I believe I have to set up an event procedure, but I am extremely new to writing code and I can not figure out how to write it properly, or if this is event the correct way to set this up. Any help would be greatly appreciated.