Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Cancelling current record

Discussion in 'Information Technology' started by John, Jul 28, 2006.

  1. John

    John
    Expand Collapse
    Guest

    Hi



    How can I cancel the current record that user has just inserted, changed a
    few fields and is still on it i.e. not saved?



    Thanks



    Regards
     
  2. Loading...


  3. John Vinson

    John Vinson
    Expand Collapse
    Guest

    On Thu, 15 Jun 2006 01:04:17 +0100, "John" <John@nospam.infovis.co.uk>
    wrote:

    >Hi
    >
    >
    >
    >How can I cancel the current record that user has just inserted, changed a
    >few fields and is still on it i.e. not saved?


    Me.Undo in VBA code on the form; or hit the <Esc> key twice (once to
    cancel the current field, once to cancel the entire record).

    John W. Vinson[MVP]
     
  4. Conan Kelly

    Conan Kelly
    Expand Collapse
    Guest

    John,

    You should be able to accomplish this by hitting the [Esc] key a couple of times.

    Hitting it once should cancel any changes to the current field/column. Hitting it again should cancel changes to the whole record.

    HTH,

    Conan Kelly
    "John" <John@nospam.infovis.co.uk> wrote in message news:O6fWH9AkGHA.4504@TK2MSFTNGP05.phx.gbl...
    > Hi
    >
    >
    >
    > How can I cancel the current record that user has just inserted, changed a few fields and is still on it i.e. not saved?
    >
    >
    >
    > Thanks
    >
    >
    >
    > Regards
    >
    >
     
  5. John

    John
    Expand Collapse
    Guest

    Thanks. Me.undo works for me but the record still remain on the new one how
    can I move the form to the last record?

    Thanks

    Regards

    "John Vinson" <jvinson@STOP_SPAM.WysardOfInfo.com> wrote in message
    news:6r9192556tg58u35rhdm4eafhfpfq9reat@4ax.com...
    > On Thu, 15 Jun 2006 01:04:17 +0100, "John" <John@nospam.infovis.co.uk>
    > wrote:
    >
    >>Hi
    >>
    >>
    >>
    >>How can I cancel the current record that user has just inserted, changed a
    >>few fields and is still on it i.e. not saved?

    >
    > Me.Undo in VBA code on the form; or hit the <Esc> key twice (once to
    > cancel the current field, once to cancel the entire record).
    >
    > John W. Vinson[MVP]
     
  6. John Vinson

    John Vinson
    Expand Collapse
    Guest

    On Thu, 15 Jun 2006 01:41:07 +0100, "John" <John@nospam.infovis.co.uk>
    wrote:

    >Thanks. Me.undo works for me but the record still remain on the new one how
    >can I move the form to the last record?


    Me.Undo
    DoCmd.GoToRecord acForm, Me.Name, acLastRecord

    John W. Vinson[MVP]
     

Share This Page