By Passing a froms Tab order to a customised one ??

[kimi2001]

I have a form with a subform on a TabCtrl.
The user moves through the form with the cursor using the Tab button on their keyboard and when it gets to the last field on the mainform the cursor/or focus then moves to the TabCtrl itself instead of what i want, which is into the first field of the subform.

I have tried messing with the forms Tab Order but when looking at the order for the main form you only get the option of jumping from the last field straight over to the TabCtrl.

Is there a solution for this, maybe a set focus function or something like that??

Kimi

 

[jabrony76]

Kimi,
You can set code in the "On Lost Focus" Event in the last control on the parent mainform form that will set focus to the first control on the child subform.

I believe this will move you to the first field on the subform after tabing out of the last control.
Andy

 

[kimi2001]

Hi jabrony,

Thanks for the suggestion but it did not work. The cursor still move to the tabCtrl fist.

Any further suggestions please?

Regards,

Kimi

 

[jabrony76]

Kimi,

My apologies, my instructions were somewhat incomplete. When writing the code (or Macro) for the "On Lost Focus" event of the last control of your main form you must first set focus to the subform. The code should look something like this:
[red]
DoCmd.GoToControl "Name_of_Subform"
DoCmd.GoToControl "Control_Name_on_Subform"
[/red]
I've tried it out on a test database and it worked for me.

Andy