Hello, I have an ADODC on my form. I want to populate the RecordSource etc. through coding
i also want to be able to Add, Update and Delete records to it in code
This is what I have so far
VB Code:
  1. Private conn As adoDB.Connection
  2. Private rs As adoDB.Recordset
  3.  
  4. Private Sub cmdBack_Click()
  5. [b]adoDBHorse.Recordset.MovePrevious[/b]
  6. End Sub
  7.  
  8. Private Sub cmdNext_Click()
  9. [b]adoDBHorse.Recordset.MoveNext[/b]
  10. End Sub
  11.  
  12. Private Sub Form_Load()
  13.  
  14.     Set conn = New adoDB.Connection
  15.     ' Point this to NorthWind.mdb sample database.
  16.     conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
  17.               "Data Source=" & CurDir & "\ST.mdb"
  18.     Set rs = New adoDB.Recordset
  19.     rs.CursorLocation = adUseClient
  20.     Set rs.ActiveConnection = conn
  21.     rs.Properties("IRowsetIdentity").Value = True
  22.     rs.Open "HorseDet", , adOpenKeyset, adLockOptimistic, adCmdTableDirect
  23.     Set adoDBHorse.Recordset = rs
  24.  
  25.  
  26. [b]txtHorseName.DataField = adoDBHorse.Recordset("strHorseName")[/b]
  27. End Sub
  28.  
  29. Private Sub txtHorseName_LostFocus()
  30. adoDBHorse.Recordset.AddNew
  31.  
  32. End Sub
But I keep getting errors on the bolded lines saying that Either BOF and EOF are true.

How can I fix this ?