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" .Open 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.