Welcome to SPN

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

Sign Up Now!

Detecting new record

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

  1. John

    John
    Expand Collapse
    Guest

    Hi

    On a form, how can I detect a new record which has not been edited by user
    yet?

    Thanks

    Regards
     
  2. Loading...


  3. Al Camp

    Al Camp
    Expand Collapse
    Guest

    IF Me.NewRecord Then......

    --
    hth
    Al Camp
    Candia Computer Consulting - Candia NH
    http://home.comcast.net/~cccsolutions

    "John" <John@nospam.infovis.co.uk> wrote in message
    news:eX4uw75mGHA.3588@TK2MSFTNGP04.phx.gbl...
    > Hi
    >
    > On a form, how can I detect a new record which has not been edited by user yet?
    >
    > Thanks
    >
    > Regards
    >
     
  4. Klatuu

    Klatuu
    Expand Collapse
    Guest

    If Me.NewRecord and Not Me.Dirty Then
    'It is a new record that has not been edited

    "John" wrote:

    > Hi
    >
    > On a form, how can I detect a new record which has not been edited by user
    > yet?
    >
    > Thanks
    >
    > Regards
    >
    >
    >
     

Share This Page