I would Like to know how to do a few things in DB's.
How do you tell the Data contoll to make a new record?
How could I tell the data contoll to save the changed data of the fields with a command button?
Thankyou!!
Printable View
I would Like to know how to do a few things in DB's.
How do you tell the Data contoll to make a new record?
How could I tell the data contoll to save the changed data of the fields with a command button?
Thankyou!!
data1.recordset.addnew 'to make a new record
data1.recordset.movenext 'i think this should save the record
Thankyou alot, But what if there is no next record??
If there is no next record, the EOF property will be TRUE. You can control this by setting the BOFAction, EOFAction of the data control.
When you want to update a recordset, you should issue the data1.Recordset.Update command before you movenext, but the fields are updated automatically anyways....