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


Not able to set Tab Indexes

Not able to set Tab Indexes

Not able to set Tab Indexes

I'm using Access 2010 on Win7.

I have a form which has only three controls: an option box (containing two radio buttons), a combo box and a button.

I want the combo box to drop down ONLY when the control receives focus. So I coded its GotFocus event with



When the form opens, the combobox drops down automatically. So I tried setting the tab indexes for the three controls. I set the button control as 0; the optionbox as 1 and the combobox as 2. But I get an error message saying: The value you used for the TabIndex property isn't valid. The correct values are from 0 to 0. It then resets all the indexes to 0.

I also tried setting the focus to the button control in the form's Activate Event. That didn't work either. The combo box still drops down.

Insights warmly welcome,

RE: Not able to set Tab Indexes


Don't know why the light dawns after I submit a post. I guess it's all part of Murphy's Law.

Anyway, the 'problem' is because the option box resides in the header; the combo box resides in the detail; and the button resides in the footer. DOH!!

Thanks for your patience.


RE: Not able to set Tab Indexes

Thanks for coming back with the explanation.

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