The following routine resets 36 Text Boxes in array:
For i = 1 to 36
Controls("ID" & i).Value = ""
Next i
It works fine.
--------------------
With the following code I get a Run-Time Error 2465
that it can't find the Field ID1

For i = 1 to 36
Controls("Forms!frmBookList!fsubSubjectsBook.Form! ID" & i).Value = ""
Next i
---------------------
I've tried to reset this value without using Controls and it does work ok.

Forms!frmBookList!fsubSubjectsBook.Form!ID1 = ""

It seems to be as with the Controls syntax it dosn't work.
-------------------------------------------------------
Later in the program I fill up the boxes with values from the database so I
cannot do it one by one 36 times.

Any Idea how to get over this problem ?

Thanks

Forms!frmBookList!fsubSubjectsBook.Form!ID1 is *not* a member of the Controls collection. Only the SubFormControl is.

__________________
HTH RuralGuy (RG for short) aka Allan Bunch MS Access MVP 2007 acXP WinXP Pro

A few things.

I see a space after the Form! and before the ID. Is that a typo in your post or is that how it actually looks in your code? Remove the space if it's in your code.

RuralGuy points out that the subform's controls are not part of the main form's controls even though the actual subform is a control on the main form. So your code may not work.

To put it in plain English, suppose your main form is a crate and your subform is a carton of eggs. I cannot see the eggs themselves. From the crate's point of view, all I see is a crate (the main form) and the carton (subform). Your code references the eggs. You may get an error message saying, "What eggs? I just see the carton." You have to open the carton and look in to see the eggs. That is, you may have to make the subform active to see its controls and reference them using that particular code.

Another note: setting values to "" is not making them NULL. You're assigning and empty string to all your controls which is actually something.

Do this: MyControl = Null
Not this: MyControl = ""

__________________
Greg Serrano
Michigan Dept. of Environmental Quality
Air Quality Division

You never posted back but I thought I'd give you a stronger hint anyway. Try:

Controls("fsubSubjectsBook.Form!ID" & i).Value = ""

__________________
HTH RuralGuy (RG for short) aka Allan Bunch MS Access MVP 2007 acXP WinXP Pro