Ms Access Properties - Events

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • dowlingm815
    New Member
    • Feb 2010
    • 133

    Ms Access Properties - Events

    I am trying to execute an event procedure after the user selects a drop-down off of an Access form. I have tried:

    - on exit
    - after update

    Looking for some suggestions...
  • dowlingm815
    New Member
    • Feb 2010
    • 133

    #2
    i believe "on change" is the best approach. it appears to be working.

    Comment

    • missinglinq
      Recognized Expert Specialist
      • Nov 2006
      • 3533

      #3
      Actually, the Combobox AfterUpdate is the usual event to use. Using the OnChange is fine until the user goes to type something into the Combobox, as when using the AutoExpand feature to find an item in the box. In that case your code will fire after each character is entered.

      What exactly are you trying to do after a selection is made and what code is being used?

      Linq ;0)>

      Comment

      • dowlingm815
        New Member
        • Feb 2010
        • 133

        #4
        Originally posted by missinglinq
        Actually, the Combobox AfterUpdate is the usual event to use. Using the OnChange is fine until the user goes to type something into the Combobox, as when using the AutoExpand feature to find an item in the box. In that case your code will fire after each character is entered.

        What exactly are you trying to do after a selection is made and what code is being used?

        Linq ;0)>
        the dropdown, pre-selected, will determined a routine. i changed to afterupdate.

        Comment

        Working...