Variable For "Forms" Statement

[lhooker]

How can I make [A1] an acceptable varible that will be allowed with the
below "Forms" statement ? That is make [A1] change to [A2], [A3 , [A4], [A5],
[A6] . . . etc.

[Forms]![Form_Questions]![A1] = varX

I tried the statement below, but it did not work.

Counter = 1

Do While Counter <= 25

QA = "[A" & Counter & "]"
[Forms]![Form_Questions]!QA = varX

Counter = Counter + 1

Loop

 

[Pat Hartman]

Eval("[Forms]![Form_Questions]!" & "[A" & Counter & "]") = varX --- might work but you really need to spend some time reading about normalization. Having a repeating group like this violates first normal form.

 

[MajP]

Cannot use variables in bang notation. Use Dot.
Forms!Form_Questions.controls(QA) =