MSDatashape Question 1

[Terpsfan]

I've created a hierarchical recordset through code using MSDatashape. I created child fields to relate to the parent. I'm not using the ADO data control. For some reason I'm not able to update and insert on the parent controls but not on the child. The child is read only. Now if I use the ADODC to bind the controls, then I can update and insert. How can I update and insert not using the ADODC? Hopefully I've made some sense.

 

[zlovelife]

This basically sets a recordset pointer to the child recordset allowing you to work with the child like you would with any other recordset.

Private Sub mysub()
Dim rs As New ADODB.Recordset

With adoPrimaryRS
Set rs = .Fields("ChildCMD&quot.Value
rs.AddNew
End With


End Sub

 

[Terpsfan]

Thanks for the response. That will work but I decided to go with a stored procedure that will validate the entries and then insert them into the table. I think this will be the best option. Thanks again