Results 1 to 3 of 3
  1. #1
    cherold is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Dec 2014
    Posts
    77

    Is there an event triggered *after* a combo box as added/changed its bound value?

    I have a combo box in a form. If I enter a new value, it will then go into a table. Once that happens I want to add something to that new row in the table. It appears all the combo box events are triggered before the value is entered into the table, which I assume is because the value is entered when I switch to a new row in the table.



    So I'm wondering if there is any event triggered in the form itself that I can use to process the table? Or some other way to call a function immediately after a row has been added to this table from this form?

  2. #2
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    6,877
    Not sure exactly what you want, but maybe this will help. When editing a record (meaning the controls on a form are bound to a table or updatable query) events for controls happen first. When you do anything to update the form (commit the changes to a record) form events occur. The first, I think, is BeforeUpdate. Various user actions will cause the form to update - moving off the record, closing the form or any code that causes this to occur. You may see a new combo selection in a table if you look, but if you haven't committed the record, you'll see the pencil on the left side of the table row, which means that updates have not yet been committed.

    So based on your comments I can't tell if you want to edit some field(s) in a record before you commit it or after that happens.
    Last edited by Micron; 02-14-2020 at 08:42 PM. Reason: clarification
    - "doesn't work" doesn't help. Implement changes in copies of your database.
    "Everyone has a photographic memory; some just don't have film." Steven Wright

  3. #3
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2016
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    14,713

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

Similar Threads

  1. Replies: 7
    Last Post: 05-17-2017, 07:39 PM
  2. Replies: 6
    Last Post: 06-29-2015, 02:21 PM
  3. Replies: 3
    Last Post: 02-17-2015, 10:25 AM
  4. Replies: 6
    Last Post: 01-30-2014, 05:57 PM
  5. Replies: 1
    Last Post: 06-09-2011, 07:11 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
  •  
Tech Forums: Microsoft Office Forums