Welcome to SPN

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

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

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
    >
     
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