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
Post a Comment