reportcontrol and database

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

hi,I am new to this control and I was wondering if there is any way to read each row of my reportcontrol and register the value of each item to a ms access database. I tried the following code, but it's not working:
    For i = 1 To RptControl.Rows.Count - 1
        .AddNew
        .Fields("Field1") = RptControl.Rows.Row(i).Record.Item(0).Value
        .Fields("Field2") = RptControl.Rows.Row(i).Record.Item(1).Value
        .Fields("Field3") = RptControl.Rows.Row(i).Record.Item(2).Value
        .Fields("Field4") = RptControl.Rows.Row(i).Record.Item(3).Value
        .Update
    Next
please let me know what am I doing wrong?
thank you,

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
ray2012 Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 09 July 2012 Status: Offline Points: 1	Post Options Post Reply Quote ray2012 Report Post Thanks(0) Quote Reply Topic: reportcontrol and database Posted: 09 July 2012 at 5:57am
	hi, I am new to this control and I was wondering if there is any way to read each row of my reportcontrol and register the value of each item to a ms access database. I tried the following code, but it's not working: For i = 1 To RptControl.Rows.Count - 1 .AddNew .Fields("Field1") = RptControl.Rows.Row(i).Record.Item(0).Value .Fields("Field2") = RptControl.Rows.Row(i).Record.Item(1).Value .Fields("Field3") = RptControl.Rows.Row(i).Record.Item(2).Value .Fields("Field4") = RptControl.Rows.Row(i).Record.Item(3).Value .Update Next please let me know what am I doing wrong? thank you,