Auto Expand a Combobox

[Iram]

Hello,
I have a subform with some fields, in particular, Category and Sub-Category.
Both of these are Comboboxes.
After Updating the Category Combobox I need the Sub-Category combobox to
automatically Open/expand. The problem is people are selecting a Category but
forgetting to check to see if there is a related Sub-Category thus this is
why I want the Sub-Category to Expand the drop down list.

Is this possible? If so how can I do this?



Thanks.
Iram/mcp

 

[Stuart McCall]

Hello,
I have a subform with some fields, in particular, Category and
Sub-Category.
Both of these are Comboboxes.
After Updating the Category Combobox I need the Sub-Category combobox to
automatically Open/expand. The problem is people are selecting a Category
but
forgetting to check to see if there is a related Sub-Category thus this is
why I want the Sub-Category to Expand the drop down list.

Is this possible? If so how can I do this?



Thanks.
Iram/mcp

Me.ComboName.DropDown

in the 1st combo's AfterUpdate event ought to do it.

 

[Iram]

I am getting a run-time error '2185', "You can't reference a property or
method for a control unless the control has the focus.

On the "Category" field, After Update I have this...

Private Sub Category_AfterUpdate()
Me.Sub_Cat.Requery
Me.Sub_Cat.Dropdown (this part becomes yellow when I debug the above error)
End Sub

re-cap
After I update the Category field I need the Sub_Cat field to open its drop
down menu.



Thanks.
Iram

 

[John W. Vinson]

I am getting a run-time error '2185', "You can't reference a property or
method for a control unless the control has the focus.

So set focus to it:

Private Sub Category_AfterUpdate()
Me.Sub_Cat.Requery
Me.Sub_Cat.SetFocus
Me.Sub_Cat.Dropdown (this part becomes yellow when I debug the above error)
End Sub