Code transfer to form!field
I am preparing a form to report on all new suggestions entered into the system by month; ie the number entered in Jan, Feb, Mar, etc.
The months are displayed in teh form as 12 fields named new_1, new_2, new_3 etc.
In the code I have obtained the numbers entered by month and stored them in an array LNew (12) as Long.
I now want to use a loop to transfer the results to the form;
eg
For i = 0 to 11
x= i + 1
Me!new_ x = Lnew (i)
Next
I am having difficulty setting up the reference to Me!new_x to change each loop to place the infotmaion on the right month field. How do I do this.
Thanks
|