By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,998 Members | 2,837 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,998 IT Pros & Developers. It's quick & easy.

Insertion of a new record

P: n/a

Hello,

in some help of Access I have read what to do for:
- write in a form tha data of a new record of a table
- update the table ONLY after the click on a push button

I don't remember where I have read all that and I can't retrieve it.
Maybe someone can help me ? Thanks.

Gianluigi
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Gianluigi <md****@mclink.it> wrote in message news:<ci***********@newsreader1.mclink.it>...
Hello,

in some help of Access I have read what to do for:
- write in a form tha data of a new record of a table
- update the table ONLY after the click on a push button

I don't remember where I have read all that and I can't retrieve it.
Maybe someone can help me ? Thanks.

Gianluigi


A form saves the record when you move off the current record, if you
want to change that behaviour you can catch that event and cancel it,
like for instance:

Private Sub Form_BeforeUpdate(Cancel As Integer)
If MsgBox("Commit changes?", vbYesNo) <> vbYes Then Cancel = True
End Sub

You can press Escape to restore the original values for the fields in
the current record. It's not entirely what you describe, but it's
easier to implement i think. You can also check if anything has
changed on the form by using "if Me.Dirty then ... "

Hope it helps,

Regards GJ
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.