Welcome to SPN

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

Sign Up Now!

Prevent Adding Record Tabbing Thru Fields

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

  1. Barkster

    Barkster
    Expand Collapse
    Guest

    How do I prevent the adding of records when tabbing through all the
    fields on a form? I want to force them to push to insert button. Do I
    have to hand code my sql to do this or is there a setting I can change
    to prevent this. Thanks
     
  2. Loading...

    Similar Threads Forum Date
    How to prevent sikh erosion? Blogs Oct 21, 2015
    Leisure Stomach Protection / Prevention for travelling to India?? Business, Lifestyle & Leisure Oct 18, 2013
    Controversial Panch Pardhani leader arrested; prevented from attending Shaheedi samagam of Bhai Jaspal Singh Hard Talk Mar 30, 2013
    World Women must play greater role in conflict prevention, UN says Breaking News Oct 28, 2011
    Sikh Coalition Bullying Prevention Summit. Register Today! Sikh Organisations Oct 19, 2011

  3. Jeff Boyce

    Jeff Boyce
    Expand Collapse
    Guest

    In the form's properties, find the one that deals with "cycling". Set it to
    "Current Record". That way, when someone tabs "out" of the "last" control
    on the form, the focus goes back to the "first" control on the form. Since
    you don't leave the form, you don't save the record.

    Now add your <Insert> command button.

    Good luck!

    Jeff Boyce
    Microsoft Office/Access MVP


    "Barkster" <bdog4@hotmail.com> wrote in message
    news:1148072131.885237.133810@g10g2000cwb.googlegroups.com...
    > How do I prevent the adding of records when tabbing through all the
    > fields on a form? I want to force them to push to insert button. Do I
    > have to hand code my sql to do this or is there a setting I can change
    > to prevent this. Thanks
    >
     
  4. John Vinson

    John Vinson
    Expand Collapse
    Guest

    On 19 May 2006 13:55:31 -0700, "Barkster" <bdog4@hotmail.com> wrote:

    >is there a setting I can change
    >to prevent this


    Set the Form's Cycle property to "Same Record".

    Tabbing past the last field in tab order will put you back onto the
    first field of the same record.

    John W. Vinson[MVP]
     
  5. Barkster

    Barkster
    Expand Collapse
    Guest

    Exactly what I needed, saved a few hours of writing huge sql
    statements. Thanks!
     

Share This Page