Using a var into the name of another var or field.
Ok, here is what I am trying to do:
Dim i As Byte
For i = 1 To 7
Set Rst = CurrentDb.OpenRecordset("SELECT * from tbl_Divisao WHERE CodigoDivisao =" & i & "and Pago = 0")
While Not Rst.EOF
sum&i = sum&i + Rst!Valor
Me.total&i = sum&i
These &i are just for the example, they dont work. I want to know how to make them work =) I mean, I want in each FOR to create sum1 to sum7 and use them in Me.Total1 to Me.Total7
hope I made myself clear....