Apply Tab Indexes and Stops to Subform Fields

[David Schaleger]

How do you set Tab Stops to "Yes/No" and the Tab Index order on specific fields in a subform in Access 2007?

I have a form with a linked subform (table and linked table) that was created with the wizard. I can set the subform itself with tab stop yes/no and the the tab index number, but I can't figure out how to set those properties specific fields within the subform itself. All I see of the subform in Design View of the main form is a white box with the table name, and the property sheet only applies to the box itself, nothing about the fields in the subform (which is still default-named "Child8").

On the main form, I tab through a couple of fields and then tab to the subform. But I only want to tab through the first 2 of 5 fields on the subform. The remaining 3 fields have default values set that will only need to be changed periodically. Thus, it's a waste of time to keep tabbing through those to get to the first field of the next record in the subform.

Thanks.

[June7]

If the Source Object of the subform is a table or query then there are no controls and no TabOrder property available to be set. The Source Object must be a form.

[David Schaleger]

Is there ANY way around this?

Could I create a form for the sub-table, and then place it on the main form in lieu of the wizard-generated one? Maybe set tabs indexes/stops on the sub-form before or after placing on the main form?

What about a VBA solution?

[June7]

Of course you can create form and use it as the Source Object of the subform container control. That is what I suggested.

Set TabOrder before or after.

[David Schaleger]

Thanks! I'm a fledgling Access developer. I've got it working the way I want it to, now, thanks to your suggestion.