Saving a record in the Form

Hi ,

beginner here. Am currently designing an user-input form. For Access , it
will save / update the table after you finish the last input cell (i.e tab
all fields).

however, I would like to disable this function and create a button "SAVE"

only when this button is clicked , will the record be save/updated into the
table

any ideas how to do that ?

-----Original Message-----
I would like to disable this function and create a
button "SAVE"

only when this button is clicked , will the record be
save/updated into the
table

On the click event of the button (called cmdSave)

Private Sub cmdSave_Click()
If Me.Dirty Then
DoCmd.RunCommand acCmdSaveRecord
End If
End Sub

I forgot to add that you can maybe have the button's
Enabled property initially set to False and Enabled the
button only when the current record is made 'Dirty'

i.e.

Private Sub Form_Dirty()
Me.cmdSave.Enabled = True
End Sub

Yes, unbind your form from the data and create a recordset to fill the form.
Then, after editing you can create another recordset to write the data back
to the table. Alternatively, you can use a temporary local table to read and
write the data.

None of this is beginner's work, so you may want to simply train your users
to use the Escape key (twice) to discard the current record you are
creating.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

"Dan" wrote in message
...
Hi ,

beginner here. Am currently designing an user-input form. For Access , it
will save / update the table after you finish the last input cell (i.e tab
all fields).

however, I would like to disable this function and create a button "SAVE"

only when this button is clicked , will the record be save/updated into
the
table

any ideas how to do that ?

While this will explicitly save the record, it will not discard any records.
You'll need to delete or undo the current record if you don't want it saved
automatically.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

wrote in message
...

-----Original Message-----
I would like to disable this function and create a
button "SAVE"

only when this button is clicked , will the record be
save/updated into the
table

On the click event of the button (called cmdSave)

Private Sub cmdSave_Click()
If Me.Dirty Then
DoCmd.RunCommand acCmdSaveRecord
End If
End Sub