Orange,
Right now I am trying to build a simple loop through many fields just to clear data. Then I'll go from there
I have 40 Fields in a table named Equip_1 through Equip_40, the column couny changes
I have determined the column count as: CurrentDb.TableDefs("Table2").Fields.Count - 6
C is an integer with a value starting at 1.
Now I want to assign "" to each field
Normally you would write ![Field_1] ="", ![Field_2] =""...….![Field_40] =""
I think this is a bit excessive and can be shortened to a few lines.
DO How would I insert the number value in?
MSGBOX "Equip_" & C gives you - Equip_1 through 40 where C-1 to 40 in a for next loop. (When you want to click OK 40 times.)
Now I am trying to insert string between the bookends to call the field I want to write to
!["Equip_" & C], But it is the incorrect syntax.