expand combo drop-down list at form open

M

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
 
B

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formatting combo box drop-down list 1
expand and retract form while open 2
combo-box drop down list not updating 1
Re-query a combo box Row Source in Datasheet view 2
Auto-Drop Down 5
Calendar Drop Down/Expand 1
Open Specific Worksheet Using Button Form Control in Excel 0
Color a drop down list 1

Top