Need help creating a button to hide any unchecked box.
$5-10 USD
Anulat
Data postării: peste 13 ani în urmă
$5-10 USD
Plata la predare
I have a form called "FRM_CHECKS" tied directly to a table with about 50 checkboxes and one ID.
so the first couple fields in the tbl look like:
ID (unique ID for each of my clients)
A
AA
ACV
ASD
BGR
ect...
For about 50 total of these shorthand codes. My form has all 50 of these checkboxes. So if "WALMART" is my client I may have about 10 of these 40 checked. If "SEARS" is a different client I may have 25 of these checked. If "TARGET" is a client they may only have 2 of these checked.
So what I want is on my form **I want to add a button that says "REMOVE UNCHECKED" which will hide/remove any of those 40 fields if they are not checked**. Clear the clutter if you would.
So if I open my form and go to the Walmart record and push that button only the 10 checked buttons will stay on the screen. The others will all go away until I leave that form to search for a different record.
**
on button click
look at current form
make any box with a current value of 0 = invisible**
I am sure this will be done at the VB level so just to make it clear I do NOT want each check box name coded into the script. These codes change often, I may delete 2 or 3 codes a month and then add 2 or 3 new codes per month. I do not want to remember to update the VB, I need the VB to simply HIDE any checkbox marked ZERO.
Thanks.
[][1]
## Deliverables
See TEST zipped file for a sample form with multiple check boxes. thanks.