Welcome to SPN

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

Sign Up Now!

Detect if change since last save

Discussion in 'Information Technology' started by Bob, Nov 4, 2005.

  1. Bob

    Bob
    Expand Collapse
    Guest

    Form - FormA that has a subform FormB. How do I detect in vb code if values
    in either form have been edited since last save?

    Thanks for any help
    Bob
     
  2. Loading...

    Similar Threads Forum Date
    Internet Detectives, Boston Bombing, and Wrongly Accused Sunil Tripathi Information Technology Apr 24, 2013
    SciTech Hint of Dark Matter Found Using $2 Billion Cosmic Ray Detector Breaking News Apr 4, 2013
    SciTech India set for building prototype gravitational wave detector Breaking News Sep 19, 2010
    Modern Sikh Detective's Malaysian Case Perfect for the Beach Book Reviews & Editorials Aug 4, 2010
    World Honour for falsely accused Cranford detective Breaking News May 14, 2010

  3. Ken Snell [MVP]

    Ken Snell [MVP]
    Expand Collapse
    Guest

    When data have been edited on a form but not yet saved to the form's
    RecordSource table/query, the form's Dirty property will be True.

    If Me.Dirty Then
    ' the form's data have been edited but not saved yet
    End If

    For the subform, if you're checking from the main form (which probably won't
    do much good, as ACCESS will save a subform's data when focus moves from the
    subform to the main form):
    If Me.SubformName.Form.Dirty = True Then

    where SubformName is the name of the subform control (the control that holds
    the subform object).

    --

    Ken Snell
    <MS ACCESS MVP>

    "Bob" <bdufour@sgiims.com> wrote in message
    news:eJRtNWN4FHA.1864@TK2MSFTNGP12.phx.gbl...
    > Form - FormA that has a subform FormB. How do I detect in vb code if
    > values in either form have been edited since last save?
    >
    > Thanks for any help
    > Bob
    >
     

Share This Page