expand combo drop-down list at form open

[Mark Kubicki]

is there a way to open a form with a combobox's
[cmbInstallationNoteSelection]
drop-down list expanded (visible) so that the user immediately recognizes
that there are choices; this control should also be the focus when the form
is opened

except for a command button to accept the current value of
[cmbInstallationNoteSelection],
this is basically the only control on the form

as always, thanks in advance,
mark

 

[Beetle]

It seems like the best solution here might be just to use a list
box instead of a combo box, but if you are set on using a combo
box, you can use code like the following in the forms Open event.

Private Sub Form_Open (Cancel As Integer)

Me.cmbInstallationNoteSelection.SetFocus
Me.cmbInstallationNoteSelection.Dropdown

End Sub

You may not even need the SetFocus if it's the only control
(other than the combo box).

Note: The combo box will return to it's un-expanded state as
soon as the user makes a selection, so this will only work once
when the form is first opened.