If space on a form is limited, a combobox is definitely more economical than a listbox. Still, you may want users to be able to see the contents of the combobox as soon as the control has

focus. That way, they can quickly pick their choice and move on. Fortunately, as with most things in Access, you can manipulate just about anything with code. You can easily use VBA to automatically open the dropdown list as soon as a combobox has focus by using the control's Dropdown method. For instance, the code can be used to display a short list of codes when the combobox receives focus.

Private Sub cboStock_GotFocus()

Me!cboCode.Dropdown

End Sub

Access Index

Main Index