Text box focus problem

[apachee]

Hi!

I'm new in Access and VBA so mybe this question will be ...

I have a main form with a lot of subforms and textboxes aswell as combo boxes and command buttons!

The problem is the TAB ORDER that I can't figure it out how to achieve the tab order that I want. Like from text box on a main form to text box on a subform and back ...

So I tried to achieve that with on keypress event! When I would press Tab or Enter it would set focus to next command!

The problem is with textboxes! When they get focus, they automaticaly set it forward on a next command!

Anyone ?

 

[Jerry Stoner]

Not sure what you mean by your last sentence but this will set focus to a control on a subform

[sfrmName of SUBFORM].Form![Name of control]

Use it in the after update event of the control you are moving from