Welcome to SPN

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

Sign Up Now!

Detecting saved data

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

  1. John

    John
    Expand Collapse
    Guest

    Hi

    I have a tab control with one tab having a sub form on it. When the tab is
    changed by user I need to detect if the form had a new record added to it by
    user which was saved as a result of user switching the tab. How can I do
    that? The reason is that my further processing depends on the fact if user
    added a new record or not.

    Thanks

    Regards
     
  2. Loading...

    Similar Threads Forum Date
    The Best $5 I Ever Saved... Inspirational Stories Oct 8, 2012
    Would We Be Saved? Inspirational Stories Dec 29, 2010
    Judaism Righteous Among the Nations: Muslims Who Saved Jews from Holocaust Interfaith Dialogues Nov 3, 2010
    India How Bombay HC saved a Hindu-Muslim marriage Breaking News Oct 4, 2010
    India Kerala professor attack: The doctors who saved his hand Breaking News Aug 5, 2010

  3. Rick Brandt

    Rick Brandt
    Expand Collapse
    Guest

    John wrote:
    > Hi
    >
    > I have a tab control with one tab having a sub form on it. When the
    > tab is changed by user I need to detect if the form had a new record
    > added to it by user which was saved as a result of user switching the
    > tab. How can I do that? The reason is that my further processing
    > depends on the fact if user added a new record or not.
    >
    > Thanks
    >
    > Regards


    Put a TextBox on the same tab as the subform and make it first in the TabOrder
    on that TabPage. That way simply changing to that page will not cause the main
    record to be saved. Then you can just test for that page being selected and the
    NewRecord property of the main form.

    The TextBox can be so small as to be effectively invisible, but it must have its
    visible property set to True so it can have focus.

    --
    Rick Brandt, Microsoft Access MVP
    Email (as appropriate) to...
    RBrandt at Hunter dot com
     
  4. RuralGuy

    RuralGuy
    Expand Collapse
    Guest

    On Sat, 27 May 2006 20:46:15 +0100, "John" <John@nospam.infovis.co.uk> wrote:

    >Hi
    >
    >I have a tab control with one tab having a sub form on it. When the tab is
    >changed by user I need to detect if the form had a new record added to it by
    >user which was saved as a result of user switching the tab. How can I do
    >that? The reason is that my further processing depends on the fact if user
    >added a new record or not.
    >
    >Thanks
    >
    >Regards
    >

    Set a flag in the forms BeforeUpdate event.
    _______________________________________________
    hth - RuralGuy (RG for short)
    Please post to the NewsGroup so all may benefit.
     

Share This Page