+ Reply to Thread
Results 1 to 1 of 1

After update of an option

  1. #1
    Forum Contributor
    Join Date
    03-24-2010
    Location
    North West UK
    MS-Off Ver
    2013
    Posts
    112

    After update of an option

    Hi,

    I have a very basic form used for entering registrations and the locations of the vehicles.

    To chose the locations a combo box is used with a drop down list. When the location is chosen it is stored in a field.

    I also have a long text box on the same form. What I would like to do is if a user changes a location of any registration the change from and to and the date of change is put in the notes box so there is a history of it.

    Is there some piece of code that could be written to say something like "Location changed from *current* to *new selection of location* on *date*. Then if it is changed again the next change is saved on a new line in the notes box? I've attached a screen shot of the form if it helps.

    Thanks,
    Lewis
    Attached Images Attached Images

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] How to update Table automatic iso recalculation option to use
    By sportfan in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-03-2015, 10:14 AM
  2. Macro to chose an option in a message box, like update, without just skipping it
    By becca0903 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-11-2015, 02:07 PM
  3. Option Button _Before Update event linked to Combo box
    By vx7g3 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-23-2014, 10:54 PM
  4. [SOLVED] Formulas to update from different worksheets depending on drop down option chosen
    By Blinkers in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-01-2013, 10:16 AM
  5. Replies: 2
    Last Post: 01-16-2012, 11:28 AM
  6. Update cell using option buttons
    By jeffreybrown in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-16-2011, 05:58 PM
  7. Replies: 2
    Last Post: 12-18-2007, 06:09 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1