Thx guys for the quick reply. i figured it out now. I know that my code is far from pretty but it works now.
For Zaehler = 0 To (Forms!frmCMP!txtAuslaufjahr - Forms!frmCMP!txtAnlaufjahr)
SQL = "insert into...
Hi what i´m trying to do ist to make a for loop to insert multiple text fields in on table.
depending on the counter (Zaehler) it should insert that representing text field. for example if Zeahler is 1 it should input whatever is inside the text field KVP_Kfm1 if its 2 then it should input the...