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

Try Me("new_" & 1).text or Me("new_" & 1).value (I forget which).

If that doesn't work, you can (for each new iteration of the For loop) loop through all of the controls on the form through its Controls collection, checking their .Name, and when you find the one that matches what you're looking for, set a reference to that control.
If you set the variable type of the object that will hold that reference as Dim x As Textbox, then that reference will have the necessary properties to handle the manipulation you are attempting in the For loop.