Hello there!! i am glad for the help i have recieved before which helped solve my problems.
my challenge now is that the following code fails to save to my Access 2007 database. it doesnt give me any errors but it does nothing. i want details i enter into the text fields saved into the database. below is a set of both the codes for the form load and the save button. Please help me.

Private Sub Form_Load()
Dim conn As Connection
Dim rs As Recordset
Set conn = New Connection
conn.Open "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Subscriptions Project\subscriptions.mdb"
Set rs = New Recordset
With rs
.ActiveConnection = conn
.LockType = adLockOptimistic
.Source = "select * from individual"
End With
End Sub

and here is the code for the Save button.

Private Sub cmdsave_Click()
rs.Fields("firstname") = txtfname.Text
End Sub

NB im not using ADODC for saving!!
Thanx you a lot.

rs.fields("somefield") = somevalue

Good Luck

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.