Field Names as variables ?

[kotzo]

Hi to all,

I want to repeat the following code 15 times, for field names me.c1, me.c2, me.c3,..., me.c15:

If Me.c1.Enabled = [URL="http://www.mrexcel.com/forum/"]True[IMG]http://cdncache1-a.akamaihd.net/items/it/img/arrow-10x10.png[/IMG][/URL] And (IsNull(Me.m1) = False Or IsNull(Me.d1) = False Or IsNull(Me.a1) = False Or IsNull(Me.q1) = False) Then
Me.m1 = Null: Me.d1 = Null: Me.a1 = Null: Me.q1 = Null
End If

The code should have the following behavior (not a real code, only as an example):

for y=1 to 15

If Me.("c" & y).Enabled = [URL="http://www.mrexcel.com/forum/#"]TRUE[IMG]http://cdncache1-a.akamaihd.net/items/it/img/arrow-10x10.png[/IMG][/URL] And (IsNull(Me.("m" & y)) = False ............................

End If

next y

How could I do this ?

Thanks for the support.

kotzo

 

[Norie]

Are c1, c2, c3... etc actually controls on a form?

 

[kotzo]

Are c1, c2, c3... etc actually controls on a form?

yes

 

[kotzo]

yes

Anyone please ?

 

[kotzo]

[CLOSED] Field Names as variables ?

Anyone please ?

.

 

[Norie]

Re: [CLOSED] Field Names as variables ?

Try this.

for y=1 to 15

If Me.Controls("c" & y).Enabled = True And (IsNull(Me.Controls("m" & y)) = False ............................

End If

next y