new to ADO

[adhikarirs]

Hi All…
I’m new in ADO and I want to create a simple application, So that I have created a form set all references.
I have 4 text boxes and I have set the properties according to Adodc1 data control.
When I’m running my application , on form load it shows values in text boxes and moving recordset according to adodc1 control. But my Problem is how can I add a new record in table. My code goes like this;
Private Sub add_Click()
Adodc1.Recordset.AddNew
Text1.SetFocus
End Sub

Private Sub save_Click()
Adodc1.Recordset.UpdateBatch
End Sub

At the time of update it gives runtime Error: “Providor called a method from IrowsetNotify in the consumer and method has not yet returned”
Please help me if you can…?
Thanks in advance……..
Adhikari.

[Ecniv]

Private Sub save_Click()
Adodc1.Recordset.Update
End Sub

Try that ...



Although I suspect since you've bound the table and controls you won't need a save...


Vince

[adhikarirs]

thanks , but suppose i want to save record according to users perception then I'm writing code for save event.
Its saving record if I'm moving through data control, but I want it to force save.
I've tried update also but its giving same problem.. any suggation pls....