Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2001

    Unanswered: Track changes made to a record.

    I am creating a user form in Access 97. I need to be able to track record changes made in the form. I found an article (Q183792) on Microsoft's Knowledgebase that comes close to what I need. They provide the sample code that tracks the record changes and puts them in a memo field. That's great, BUT, I need to track the changes in a separate table. Any ideas?


  2. #2
    Join Date
    Oct 2001
    Bay Area, CA
    I usually create a table with 5 fields, ID (foreign key that will be linked 1:1 to the main table), DateCreated, UserCreated, DateLastUpdate, UserLastUpdate. You can log users and dates(times) using your form by
    A.. Create a query that links the two tables, because the relationship is 1:1 you can update the query, then use the query for the form record source.
    B.. Add the log table as a subform and pass values from the main form.

    Regarding the Microsoft solution, avoid memo fields as much as you can.

    Hope this helps....

Posting Permissions

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