Is it possible to set MSAccess form object properties using variable substitution?
Posted on 2007-08-08
I have an MSAccess form that have 10 label and 10 text fields. All fields are all set to invisible, and disabled, and depending on what selection the user selects, anywhere from 1 - 10 fields will become visible and the label captions will get set. My question is this...depending on the selection, the label captions will be set to different things. I want to set them using a loop. The labels are called lblparm1, lblparm2, lblparm3, lblparm4, etc. How can I set this using a loop or can I do that at all. Can I do something like this:
for x = 1 to number of parms in query
strlabel = "lblparm" & cstr(x)
strlable.caption = .........
I tried this but it doesn't work. Is it possible?