close button in an Access form

[Toral Shah]

hi! plz help me out with this.
i have created a small program of data entry and have this problem
well whenever i close the form with the close button on the form it saves the record.
i dont want the record to be saved withour pressing the save button.
plz give a solution for this

[Lysander]

hi! plz help me out with this.
i have created a small program of data entry and have this problem
well whenever i close the form with the close button on the form it saves the record.
i dont want the record to be saved withour pressing the save button.
plz give a solution for this

One solution would be to disable the close button on the form and add your own close button. Then check in the code if the record has been changed (me.dirty=true I think) and if so, either refuse to let the form close, or undo the changes before closing.

A second option, and I think a better one if the system is multiuser, is to use unbound forms so that the only way to save the data is via your Save button.

[Toral Shah]

One solution would be to disable the close button on the form and add your own close button. Then check in the code if the record has been changed (me.dirty=true I think) and if so, either refuse to let the form close, or undo the changes before closing.

A second option, and I think a better one if the system is multiuser, is to use unbound forms so that the only way to save the data is via your Save button.

if i use the save button to save the record in the unbound form
how will i do it with a code
will the insert into cose work in MS Access

[MMcCarthy]

Dim strSQL As String
 
   strSQL = "INSERT INTO TableName (Field1, Field2) VALUES (" & _
      Me.textbox1 & ", '" & Me.textbox2 & "')"
   DoCmd.RunSQL strSQL
 

In this example Field1 is a number datatype and Field2 is a text datatype.