ComboBox.Dropdown - Access Developer Forum


	Back to Access Developer Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

ComboBox.Dropdown

Gregory Clancey

3 years ago

LOW PRIORITY ISSUE

FormA opens FormB with CommandButtonOPEN. This 2nd Form (B) has a ComboBox populated with [string] values, one of which I select; then the selected string is copied to the original FormA with code that includes, Forms!FormA!TextBoxSTRING, and then closes itself via VBA.

No code functionality problems here; however, I would like FormB's Combobox to get the Focus as well as "Dropdown" immediately when its Form is opened. Currently, FormB's tab order does put the focus on the ComboBox, but no Event fires the Dropdown code.

Where would you recommend I place the <coboBoxNAME>.Dropdown to cause this action (or is it even doable)?

Thanks.

	Kevin Robertson @Reply 3 years ago
I would put the code in the Button that opens the form.

	Gregory Clancey OP @Reply 3 years ago
Thanks. I'll give it a go this morning.

	Gregory Clancey OP @Reply 3 years ago

	Gregory Clancey OP @Reply 3 years ago
I wonder, Kevin, if I'm just barking up the wrong tree? What I've been doing is making an empty TextBox first in the tab order when FormB opens, out of which an <ENTER> navigates to the Combo where its ON GOT FOCUS can trigger the action. I can live with this. Now, the wife of 40 years may be another matter. . .

	Kevin Robertson @Reply 3 years ago
You need to set the focus to the Combo Box first before dropping i down. `Docmd.OpenForm "FormName" Forms!FormName!ComboName.SetFocus Forms!FormName!ComboName.Dropdown`

	Gregory Clancey OP @Reply 3 years ago
Thanks. Got it. When the experts turn a light on, I can see my way around.

	Gregory Clancey OP @Reply 3 years ago
Works like a charm, lad. Thanks! . . .that takes care of the wife, and now for the database control. . .

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Developer Forum.

Next Unseen

New Feature: Comment Live View