Problem with drop-down options being visible

[breezett93]

Hello,

I have a form with multiple drop-downs. The process is to start with the first, choose an option, and then move on to the second drop-down. This works just fine if the user clicks on the drop-down for the first, then clicks on an option, and then moves on.

However, because the focus is on the first drop down, efficient users will simply type the first couple letters to get to the item they want. Then they will tab to the next drop-down which shows up blank. It seems strange that the user actually has to click the option in the first drop-down for the second drop-down to show any choices.

Help on changing this would be great!

 

[dhookom]

How are you limiting the dependent drop-downs? Are you using code to update the Row Source properties or some other solution?

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016

 

[breezett93]

There is code in the After Update with cases for the different choices. That is updating the Row Source.

Here is an example:

Select Case [Group]
        Case "Option1"
            [TypeCombo].RowSource = "Select  [Descr], [Field1Id] from [Field1Tbl]"

Why would the combo box not recognize the text unless something was clicked on instead of typed in?

 

[dhookom]

That is only part of the code. Try set a breakpoint in your Code so you can step through it.

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016