Is there a way to make my subform (or any other form, for that matter) tab through the "Option Group" controls/selections? ... and then out to the rest of the Form's controls?

You know; say you have the 'checkboxes' "YES" and "NO" within the option group. I would like it to tab to or through these selections...and then out to the rest of the Form's controls. Thanks.

Al T.

If you are tabbing though how do you indicate which of the possible selections in the option group to select? Currently you have to click on the one you want using the mouse and you are good to go, but at the moment I cannot think of a way to tab through and still make a selection without using the mouse or another key press...

My 3 cents worth...

Jack

Yes, that's kind of what I thought...looking at the 'mechanics' of it.

I guess this is just part of my "learning curve" as I improve with Access. More thinking. More practicing, experimenting, etc...more 'why' questions.

Thanks, Jack

Al T.

Al T.

You are most welcome! Glad to be of assistance and just keep plugging away!!!

Jack

I was asked to do a similar tab through option list and came up with this:


The code was placed in the key down event of each option where Frame11 is the containing frame. The 'Me![Frame11] = 3' is amended so that the tab cycles round all option in the frame until the shift key is held when tabbed and then the focus then moves to the next control (here 'TextBox'),

If the tab has cycled round all values the control will also go to the next control (when intOpt = the initial value) intOpt is set to zero in the Frame11_Enter event. intOpt is defined as a private variable at the top of the code window:



Hope this helps (or maybe of some interest!)

Edited by: pere_de_chipstick on Tue Apr 29 5:28:26 EDT 2008.

Thanks Pere!

I'll try this out and see how it works. I kind of figured that all that was needed was some kind of 'event' trigger
--- with the right code, of course. Thanks again.

Al T.

You're welcome

Hope the code gives you what you wanted.