A button drop list allows a user to select one item from the list.
The BeforeUserChanged and AfterUserChanged events occur when the user selects an item from the list. The BeforeGotFocus and AfterGotFocus events occur as the user presses the button. The BeforeLostFocus and AfterLostFocus events occur when the button returns to its “unpressed” state. Setting the value of a button drop list through VBA runs the list’s Changed event.
VBA uses a numeric value (1 to n) when referencing an item in a button drop list. In most cases, the value corresponds to the order of the selected item in the list. You cannot reference the name of an item in the list, nor can you rearrange, remove or add items to a button drop list using VBA.
In certain instances, the position of an item in a button drop list doesn’t necessarily to its numeric value. This is especially true if the list is sorted in alphanumeric order. To determine the correct value, select the item in the list, then view the field’s Value property using the Visual Basic Editor’s Property sheet.
The following event procedure chooses the first item in the Write Letters button drop list in the Customer Maintenance window.
Private Sub PrintCollections_Click() 'Print a collections letter CustomerMaintenance.coWriteLettersBDL = 1 End Sub