Update Method

The following newrecord() and saverecord() functions could be attached to command buttons on your form titled "New" and "Save" respectively. These functions allow you to create a new record in the open recordset and update that record with values of fields on your form.

JSCRIPT

// Add a new record to the recordset

function newrecord()

{

SampleRecordset.AddNew ();

clearrecord ();

}

// Save any changes to the current record

function saverecord()

{

setrecord ();

SampleRecordset.Update ();

}

// Clear the fields on the form

function clearrecord()

{

App.ActiveForm.CustomerName.Text = "";

App.ActiveForm.CustomerNumber.Text = "";

App.ActiveForm.Balance.Caption = "";

}

// Update the current record with the details from the fields on the form

function setrecord()

{

SampleRecordset.Fields(0).Value = App.ActiveForm.CustomerName.Text;

SampleRecordset.Fields(1).Value = App.ActiveForm.CustomerNumber.Text;

SampleRecordset.Fields(2).Value = App.ActiveForm.Balance.Caption;

}