vba - Cycling through textboxes on form in MS Access -


i'm trying index through multiple textboxes in form change visible property through after update event. event occurs after combo box designates number of textboxes cycle through. textboxes named "v1, v2, v3...v110, etc.) i'm relatively new vba , access, how go coding this?

you can use following sub

    option explicit      sub changetextboxvisibility(imin long, imax long, visibilitystate boolean)         dim long         me             = imin imax                 .controls("v" & i).visible = visibilitystate             next         end     end sub 

to called as

changetextboxvisibility 3, 90, false'<--| set not visible textboxes "v3" "v90" 

Comments