How do you Tab from the Main Form to Sub-Form?

[Azie]

I am wanting the tab automatically from the last field in the Main Page to the First Field in the Sub-Form.

 

[jebry]

Hi!

If you go to View / Tab Order, a window will pop up which will allow you to look at the tab order of the controls on the form, including the subform. After you adjust the tab order the way you want it, then go to the individual controls and make sure their Tab Stop property is set to yes. Then do the same for the subform.

hth
Jeff Bridgham

 

[Guest_imported]

Thanks but it is still going to the top of the Main Form instead of the Sub-Form

 

[ShaneBrennan]

Create an On Exit event for the last tab item on your main form.

You then need VBA to set the focus to the 1st tab item in your subform - similar to the following:

forms![MySubForm]![MyFirstField].setfocus

I think
Shane Brennan
Shane.Brennan@tcat.ac.uk

 

[jebry]

Hi!

All I have ever needed to do is to set the subform as the last tab item of the main form's controls. Access has always automatically gone from the main form to the subform if I do that. So I am not sure what is happening if it isn't working for you.

Sorry :-(
Jeff Bridgham

 

[tlbroadbent]

Check faq702-1064 in the Access Forms forum. Terry L. Broadbent
faq183-874 contains some tips and ideas for posting questions in these forums. Please review it and comment if you have time.
NOTE: Reference to the FAQ is part of my signature and is not directed at any individual.