Welcome to SPN

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

Sign Up Now!
  1. Monthly (Recurring) Target: $300 :: Achieved: $95
      Become a Supporter    ::   Make a Contribution   

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]
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page