Tab order between objects on form and objects on tab control

[RaoAli]

One of my form having many text boxes and a tab control with 3 tabs.
I have set the tab order for the form, but the problem is that the focus moves from the control on form to tab but not to the text box on to the tab.

on pressing enter key,Instead of focus shifting to an object in tab, control moves to the next record.

I want the control to flow from last object on form to the first object in tab and from one tab to another tab and so on till the last tab and last object.

[twinnyfo]

RaoAli,

Unfortunately the Tab Order doesn't work as you desire by default.

The only way you could do this is by managing all the On Focus, Lost Focus and After Update events of all the controls involved. You might also want to think about restricting addition of records once the current record is begun (which can become a bit tricky.

Another option would be to have all the controls on one tab or on one form, but my presumption is that you are using different data sets, which could overly complicate things.

There are some more complex and complicated solutions, like using unbound controls on an unbound form, but that goes very contrary to standard DB principles, and adds a level of complexity that I don't think you want to get involved in.

[RaoAli]

you are right.........your response been quite useful. Thank YOu :)