Export (0) Print
Expand All

ComboBox.Dropdown Method (Access)

You can use the Dropdown method to force the list in the specified combo box to drop down.

expression .Dropdown

expression A variable that represents a ComboBox object.

Return Value

Nothing

For example, you can use this method to cause a combo box listing vendor codes to drop down when the vendor code control receives the focus during data entry.

If the specified combo box control doesn't have the focus, an error occurs. The use of this method is identical to pressing the F4 key when the control has the focus.

The following example shows how you can use the Dropdown method within the GotFocus event procedure to force a combo box named SupplierID to drop down when it receives the focus.

Private Sub SupplierID_GotFocus() 
 Me!SupplierID.Dropdown 
End Sub
Show:
© 2014 Microsoft