Error when adding record on a recordset openned by a view.

[Gaston]

Set ListDescRs = New Recordset
ListDescRs.CursorLocation = adUseClient
Set ListDescRs.ActiveConnection = Conn
ListDescRs.Open "Select * from cpo_ped_view where codpedido = " &
abmForm.SelectionID & " order by codcpoped", , adOpenKeyset,
adLockOptimistic

Set ListDescRs.ActiveConnection = Nothing
ListDescRs.AddNew
FormPedido.ListDescRs.Fields("producto") = "SWEATER" --->>>> ERROR
IN THIS LINE



ERRORRR

 

[Klatuu]

You are closing the recordset before doing the .addnew

Move this line:

Set ListDescRs.ActiveConnection = Nothing

to be the last line in your code.

Setting the object to Nothing closes the recordset.