Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Posts
    145

    Unanswered: Track bound form changes

    I have a couple bound forms that I would like to log the changes for. My first thought was to loop through and store control values when the record is loaded and then do the same when the record is unloaded and compare the two. Can Access give me this info (so I don't reinvent the wheel) or is there a better way? I'm running Access 2003 on XP Pro, but the DB is in Access 2000 format, we have one person running Access 2000 on Win 98SE.

    I suppose I could do on_change events, but that would be alot of work.

    TIA for any comments, suggestions.

  2. #2
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    option explicit
    dim hasChanged as boolean

    private sub Form_Dirty()
    hasChanged = true
    end sub

    private sub Form_Unload()
    if hasChanged then
    'blah blah blah
    endif

    ? izy
    currently using SS 2008R2

Posting Permissions

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