I need to confirm an unexpected (and unintuitive) observation about the order of events for Access comboboxes.
All the documentation I ever read (going way back) regarding the order of events for Access controls says the Change event precedes the AfterUpdate event.
This seems true if the user modifies combobox text (or selects a list item with an arrow key) before moving focus.
If, however, they select a list item with the mouse before moving focus, then the AfterUpdate event appears to raise before the Change event.
The particulars are:
- Windows 7 (64 bit)
- Access 2010
- Unbound form
Also, potentially-relevant combobox properties are:
- Column Count = 1
- Column Heads = False
- Limit To List = True
- Allow Value List Edits = False
- Inherit Value List = False
- Show Only Row Source Values = False
- Auto Expand = True
It does not seem to matter if the Row Source Type of the combobox is Table/Query or Value List.
Is this behavior documented (or common knowledge among Access developers)? If not, can anyone reproduce/explain it?