I m new with VB. I m trying to add data from VB interface to Microsoft access. But its showing "Compiler error: Method or data member not found" error.n its highlighted at Private Sub cmdOk_Click()

My code is as follows:

Private Sub cmdOk_Click()
Dim rs As New ADODB.Recordset
mdldb.dbconnect
Dim sql As String
On Error GoTo errorhandler

if anyone could help me with this, i would really appreciate.

sql = "insert into StudentProfile values ('" & txtID.Text & "','" & txtDob.Text & "','" & cmbTitle.Text & "','" & txtFname.Text & "','" & txtMname.Text & "','" & txtLname.Text & "','" & cmbGender.Text & "','" & txtNationality.Text & "','" & txtHouseNo.Text & "','" & txtStreet.Text & "','" & txtCity.Text & "','" & txtPoCo.Text & "')"
valid

If isValid = 1 Then
  mdldb.dbconnect
  mdldb.conn.Execute (sql)
  txtID.Text = txtID.Text + 1
  Reset
End If
Exit Sub
errorhandler:
   MsgBox Err.Description

that is odd. I am wondering if there is something "before" that line that is causing the error. Can you post some of the previous the lines? Do you have Option Explicit? How is mdldb declared?

BTW try running with a full compile (Ctrl+F5), you get compile errors right away and usually they are more descriptive

Marco