How to programmatically access a property of a vba access object/module? like self["property" + i]?

Question

I have a form which has 12 objects named sequentially: object0, object1, object2... and I would like to do something like a loop to get all the values instead of doing the same thing for each one.

Like:

self["object" + i]

in a loop where the i is the current number

Fionnuala · Accepted Answer · 2013-03-27 12:10:14Z

3

You can refer to Me:

Me("Object" & i)

When the code is running in the form's module. Or elsewhere:

Forms!TheFormName.Controls("Object" & i)

Or even

Forms![Some Form Name]("Object" & i).Value

edited Mar 27, 2013 at 12:10

answered Mar 27, 2013 at 11:56

Fionnuala

91.4k7 gold badges121 silver badges155 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to programmatically access a property of a vba access object/module? like self["property" + i]?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related