hi, when i run the following code, an error arises when i click the save button, it asks for an object to be mentioned. The code is as follows:
CODE
Private Sub Form_Load()
Set db = New ADODB.Connection
Set rs = New ADODB.Recordset
db.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and Settings\Administrator\My Documents\vaish vb\vaish.mdb;"
rs.Open "select Name,Age from dbagain", db, 3, 3
End Sub
Private Sub cmdsave_Click()
rs.AddNew
rs("Name") = name_text.Text
rs("Age") = age_text.Text
rs.update
End Sub
can anyone please guide me abt this??