Navigating from form to subform to subform

[New_User]

Hello,
I have a form with three different subforms on it. I would like to be able
to insert information into all four forms in order by pressing the tab button
and moving from the main form to the subform to the next subform to the next
subform without the subform moving forward, to another blank record. In other
words, I want the information I just inputted in one form to remain visible
while the focus now moves to the next subform. Is this possible? Any
suggestions?

 

[Tom van Stiphout]

On Thu, 5 Feb 2009 15:00:18 -0800, New_User

Yes that is possible. Perhaps you are OK with using the standard
built-in keystrokes? Use Ctrl-Tab to get out of a subform back to the
mainform.
Otherwise you can create tiny barely visible textboxes in the tab
order and write code in their LostFocus event. When you tab around and
get to one of them and tab again, your code would use the SetFocus
method to set focus somewhere else.

-Tom.
Microsoft Access MVP

 

[New_User]

Thank you Tom! I had no idea there was a built-in keystroke to do this.
But incase I want to do it the other method you metioned, can you help me
with the code for the textboxes?
Thank you,
Virna

 

[Tom van Stiphout]

On Fri, 6 Feb 2009 20:36:09 -0800, New_User

You would call SetFocus in the control's LostFocus event.

-Tom.
Microsoft Access MVP