Tabbing Between Form/Subform

  • Thread starter Thread starter Josef
  • Start date Start date
J

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.
 
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.
 
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
 
M.L. Sco Scofield said:
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
Click to expand...


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

< g >
 
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
 
M.L. Sco Scofield said:
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
Click to expand...


< bg >
 
Back
Top