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.

8 Years
Discussion Span
Last Post by Israelsimba
This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.