Hi,
I'm trying to fill a drawn matrix on a form.
There 50 fields I have to set (text and color) since the amount of fields can change I want to make a program to set the fields.
It's the same opperation all the time (just the field name is differnt)
This is what I'm trying
Dim a As Long
Dim jan As Object
Dim az As String
a = 0
az = "BackColor"
Set jan = Forms![matrix]![c0r0]
CallByName jan, az, VbLet, a
All what I need to know is how to change [c0r0] to C1r1 etc.
In otherwords get the object definition into a string.
However I can't find the way to do change that bl... string.
I tried almost all day with differnt methods like eval() etc etc
Who can help me
I'm trying to fill a drawn matrix on a form.
There 50 fields I have to set (text and color) since the amount of fields can change I want to make a program to set the fields.
It's the same opperation all the time (just the field name is differnt)
This is what I'm trying
Dim a As Long
Dim jan As Object
Dim az As String
a = 0
az = "BackColor"
Set jan = Forms![matrix]![c0r0]
CallByName jan, az, VbLet, a
All what I need to know is how to change [c0r0] to C1r1 etc.
In otherwords get the object definition into a string.
However I can't find the way to do change that bl... string.
I tried almost all day with differnt methods like eval() etc etc
Who can help me
