Results 1 to 3 of 3
  1. #1
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Won't recognize Dirty event (Access2000)

    I've encountered a bizarre occurance in one particular form. It won't recognize the "Dirty" event when on a new record.

    I've placed a breakpoint in the Dirty event code to verify this. The event fires when an existing record is dirtied, but not a new record! And I know it is dirty by checking both the record selector (which displays the pencil) and manually check the form's dirty property via the immediate window.

    This works fine with other forms, just not this one. Can anyone offer an explanation?
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Won't recognize Dirty event (Access2000)

    If you modify a record in VBA (for example, if you populate controls in the Before Insert event), the On Dirty event does not occur. Do you have something like that?

  3. #3
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Won't recognize Dirty event (Access2000)

    That was it! Thanks. I was trying to figure out how this form differed from all the other forms in which this worked! And in this one form I did have some code in "Before Insert" that populated a field in the record, not something I routinely do.

    Thanks again. This was beginning to be one of those "This is ridiculous, there is no reason why this shouldn't be working here!".
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •