Tabbing Between Form/Subform

[Josef]

Is there any easy methos to tab between forms and subforms.

my form has a subform as the first tab index. all the fields in this
form tab thru ok. when at the end it cycles thru again.

i would like for it to exit the subform and tab to the main form. i have
looked at the tab order and things look ok. other forms work fine, just
subforms giving me grey hairs.

cheers.

 

[Ken Snell]

In the subform, create a textbox. Make its height = 0 and its width = 0.
Make it the last control in the tab sequence.

On the OnGotFocus event of this textbox, put code similar to this:

Private Sub txtBoxName_GotFocus()
Me.Parent.ControlNameOnMainForm.SetFocus
End Sub

Replace ControlNameOnMainForm with the name of an actual control on the main
form. Do not change Parent to anything else.

 

[M.L. Sco Scofield]

Did you try help? There is an amazing amount of information there.

The first answer I got when searching for "subform tab" ( and "tab subform")
was "Move between a main form and a subform in Form view."

It says to use CTRL+TAB and CTRL+SHIFT+TAB.

Sco

 

[Ken Snell]

Did you try help? There is an amazing amount of information there.

The first answer I got when searching for "subform tab" ( and "tab subform")
was "Move between a main form and a subform in Form view."

It says to use CTRL+TAB and CTRL+SHIFT+TAB.

Sco

Now, Sco -- be fair here... you used A97 Help, didn't you?!

< g >

 

[M.L. Sco Scofield]

Hey Ken,

Actually, it was 2003 help!

What they told us in Redmond is true. They *are* actually fixing the online
Access 2003 help daily. I've tried to demonstrate how bad it was in several
of my classes the last few weeks and was shocked that I found what I was
looking for every time.

No more bad-mouthing Access 2003 online help.

Sco

 

[Ken Snell]

Hey Ken,

Actually, it was 2003 help!

What they told us in Redmond is true. They *are* actually fixing the online
Access 2003 help daily. I've tried to demonstrate how bad it was in several
of my classes the last few weeks and was shocked that I found what I was
looking for every time.

No more bad-mouthing Access 2003 online help.

Sco

< bg >