Simply DB Questions

[Dayo312]

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

[Dayo312]

Thankyou alot, But what if there is no next record??

[Clunietp]

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