Can't remember how to do this

[CD Tom]

have you ever tried doing something and just can't remember how to do it. Well that's what happened here.
I have 16 bonus labeled bonus1 through bonus16 in a table, the design of the database was done a long time ago and it's to large to change the design at this time.
So instead of setting up 16 separate commands I would like to use a subscript I to change each bonus.

me.Bonus1 = 0

to something like

me."bonus" + i = 0

this doesn't work and I've tried many different approaches and keep getting some sort of error.
Can someone show me the correct format to do this or is it not possible.

Thanks.

[PhilOfWalton]

Try

me."bonus" & Chr$(i) = 0

Phil

[CD Tom]

I tried that and get the following error> "Compiler error: Expected identifier or bracketed expression" if I put brackets around it I don't get an error until I run it

me.["bonus" & chr$(i) = 0]

then I get this error Can't find the field'|1' referred to in your expression.
I've tried every possible [ and keep getting errors.

[PhilOfWalton]

OK, I gave the cut down version

I don't know where you are running the code, but you should have something like

Sub XXX
    Dim i As Integer
    For i = 1 to 16
        Me.Controls("bonus" & Chr$(i)) = 0
    Next i
End Sub

I actually don't believe the word "Controls" is strictly necessary.

Phil

[CD Tom]

Ok that will work. Thanks

[twinnyfo]

Phil is also correct:

Me.("bonus" & Chr$(i)) = 0

will work perfectly fine.