Results 1 to 3 of 3
  1. #1
    David Bratby is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    Nov 2015
    Posts
    2

    Combo Box and Append History

    Hi,



    I have a form with a combo box, that has a list in it.

    I want a box on my form that records when the combo box was changed.

    Can anyone tell me how to do this? I have used the append column history before. But can't seem to get my head around this.

    Thanks in advance.

    Dave

  2. #2
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,928
    duplicate post here

    http://www.access-programmers.co.uk/...d.php?t=286563

    @Dave - please read this link which you may find helpful

    http://www.excelguru.ca/content.php?184

  3. #3
    NTC is offline VIP
    Windows 7 64bit Access 2013
    Join Date
    Nov 2009
    Posts
    2,392
    In the AfterUpdate event of the Combobox you have code that writes a value into the field control that is to record the change. It is not clear what you intend to write; perhaps "Updated" or maybe a date. So it would be something like:

    Me.RecordingFieldName = "Updated"

    the conceptual issue is of course what is the validity of this after the first change......

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 6
    Last Post: 06-01-2015, 03:03 PM
  2. Replies: 15
    Last Post: 07-20-2013, 12:42 PM
  3. MS Access Combo Box/Append Query
    By fallenangel820 in forum Forms
    Replies: 1
    Last Post: 03-03-2013, 02:10 PM
  4. Replies: 1
    Last Post: 10-06-2011, 08:37 AM
  5. Replies: 7
    Last Post: 07-21-2011, 01:01 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums