son kararınız eğer toplu borçlandırmayı T_1_MemberDues tablosuna eklemek ise aşağıdaki kod işinize yarayabilir

'hy ekle________________________________

ClngAidat = CLng(Me.txtAidatTutari / 12)

StrEkle = " INSERT INTO T_1_MemberDues (  " & _

          " UyeNo, Tarih, AidatTutari, TaksitSayisi, Ocak, Subat, Mart, Nisan, Mayis, Haziran, Temmuz, Agustos, Eylul, Ekim, Kasim, Aralik ) " & _

          " SELECT  " & _

          " Gcc.UyeNo, Gcc.Tarih, Gcc.AidatTutari, Gcc.TaksitSayisi, Gcc.Ocak, Gcc.Subat, Gcc.Mart, Gcc.Nisan, Gcc.Mayis, Gcc.Haziran, Gcc.Temmuz, Gcc.Agustos, Gcc.Eylul, Gcc.Ekim, Gcc.Kasim, Gcc.Aralik " & _

          " FROM  (SELECT T_1_MemberDefinition.UyeNo, " & CLng(Me.txtTarih) & " AS Tarih,  " & _

          " CCur(" & Me.txtAidatTutari & ") AS AidatTutari, 12 AS TaksitSayisi,  " & _

           ClngAidat & " AS Ocak, " & ClngAidat & " AS Subat, " & ClngAidat & " AS Mart, " & ClngAidat & " AS Nisan,  " & _

           ClngAidat & " AS Mayis, " & ClngAidat & " AS Haziran, " & ClngAidat & " AS Temmuz,  " & _

           ClngAidat & " AS Agustos, " & ClngAidat & " AS Eylul, " & ClngAidat & " AS Ekim, " & ClngAidat & " AS Kasim,  " & _

           ClngAidat & " AS Aralik " & _

          " FROM T_1_MemberDefinition " & _

          " ) as Gcc"

 CurrentDb.Execute StrEkle

'hy ekle________________________________