×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Problem with drop-down options being visible

Problem with drop-down options being visible

Problem with drop-down options being visible

(OP)
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!

RE: Problem with drop-down options being visible

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

RE: Problem with drop-down options being visible

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

Here is an example:

CODE

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?

RE: Problem with drop-down options being visible

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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close